Questions

1. How do you gather information about a table you want to insert, update, or delete data from?
2. How do you insert data into a new table from an existing table in MySQL?
3. How do you limit data to be deleted?
4. What's an alternative way to delete all the rows in a table?

5. How do you update data based on another table?
6. What is an SQL transaction?
7. How do you use transactions in MySQL?
8. How do you add a column to a table?
9. How do you change the data type of a column?
10. How do you rename a column?