My Computer Forum Computer Science Forum

Go Back   My Computer Forum > Web Development Forum > Web Databases

Web Databases Web Databases and SQL

LinkBack Thread Tools Display Modes
April 22nd, 2012, 01:30 PM   #1
Site Founder
julien's Avatar
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 !
julien is offline  

My Computer Forum is free to register and we welcome everyone!


  My Computer Forum > Web Development Forum > Web Databases

correctly, executed, query, sql, verifying

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Answer of an query in an array? HannoD Programming 3 September 1st, 2012 07:09 AM

Copyright © 2019 My Computer Forum Forum. All rights reserved.