1.How do you specify what records are changed in the update statement?

 

2. When you wish to update a single record, what is the best way to specify that record?

 

3. What happens if you do not place any criteria on the update statement?

 

4. What option needs to be disabled in MySQL Workbench to update or delete without referencing the primary key field?

 

5. What is a good way to test your criteria before doing an update statement to ensure that only the records you intend to update are updated?

Answer rating: 100% (QA)

Question 1 Answer In an update statement you specify what records to change by adding a WHERE clause ... View the full answer