My Computer Forum Computer Science Forum

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

Web Databases Web Databases and SQL


Reply
 
LinkBack Thread Tools Display Modes
April 22nd, 2012, 02: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!

Reply

  My Computer Forum > Web Development Forum > Web Databases

Tags
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 08:09 AM





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