julien

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 !