Sql updating multiple tables
Through the ticking of this option, the software could prevent you from losing significant amounts of data or some of the changes you made earlier.However, it could also eliminate the possibility of the state of the data in our database.Of course, we can still say we have updated the specific record! After that, we will select the same employee through the employee number once again. Please note the following feature of the UPDATE statement.Had we used a non-existent condition in the WHERE clause (for instance, an employee number of 999909), My SQL would have allowed the execution of the query, given that the SQL syntax is correct.Remember, you should be careful when using this command because once you execute COMMIT, you cannot reverse any change!So, after running ROLLBACK, where will we go back to? We see the information we had in the “Departments Duplicate” table at the beginning of this post.
We can expand the Edit tab from the Main Menu and opt for “Preferences”.On the left-hand side of the window that pops up, choose the “SQL Editor” section.On the right-hand side, scroll down to get to the box that says, “Safe Updates”.Before reading this post you may want to get familiar with our post about SQL INSERT Statement.ROLLBACK is a command that can bring the state of the data a step back, but not more than that.