![]() | ![]() |
|
Web Databases Web Databases and SQL |
![]() |
| LinkBack | Thread Tools | Display Modes |
April 22nd, 2012, 01:30 PM | #1 |
Site Founder Joined: Dec 2007 Posts: 414 | Verifying that a SQL query has executed correctly
Hello dear computer forums members ! While coding a platform I came up with the following SQL programming question: how can you make sure that a SQL query has executed properly ? Say you are running a SQL insert or SQL update over a table of your database. How can you be sure that the proper data has indeed been inserted in the table you expected ? Do you have to perform a MySQL SELECT in order to verify yourself ? I know that SQL TRANSACTION allows you to COMMIT to a number of queries only if these are properly executed; can you really trust this ? How do you know that the data which was inserted in your table wasn't corrupted ? Thanks for any input on this ! |
![]() |
My Computer Forum is free to register and we welcome everyone! |