Chapter 8

1. USE yourschema;
   describe managers;
2. CREATE TABLE newtablename
   SELECT * FROM existingtablename
3. By using a WHERE clause.
4. TRUNCATE TABLE tablename;
5. UPDATE table1 t1
   INNER JOIN table2 t2
   ON t1.id = t2.id
   SET t1.col1 = t2.col1
6. A grouping of one or more changes to the database.
7. To start a transaction in MySQL, use the START TRANSACTION or BEGIN keywords. To commit the transaction, you use the COMMIT keyword. To roll back a transaction, use the ROLLBACK keyword.
8. ALTER TABLE table1
   ADD COLUMN col2 datatype constraint AFTER col1;
9. ALTER TABLE table1
   CHANGE COLUMN col1 col1 newdatatype;
   ALTER TABLE table1
10. CHANGE COLUMN col1 col1a datatype;