Best practices for updating data base
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”.Check what we have in the “Departments duplicate” table – nine rows and two columns with information. For the sake of this exercise, we will change all the department numbers and names in this table. “Departments Duplicate” is a table now comprising identical rows!
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.Please note that it will be very hard to practice these statements unless we switch off the following feature of Workbench.We can expand the Edit tab from the Main Menu and opt for “Preferences”.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.