Learn SQL Database Programming

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;