My SQL: How to create a TABLE

, sql , MySQL, table 00:00:00 Intro 00:00:36 CREATE TABLE 00:03:00 SELECT FROM TABLE 00:03:21 RENAME TABLE 00:03:54 DROP TABLE 00:04:11 Add a column 00:05:13 Rename a column 00:05:50 Modify a column 00:06:34 Change column position AFTER 00:07:32 Change column position FIRST 00:07:52 Drop a column 00:08:09 Conclusion CREATE TABLE employees ( employeeid int PRIMARY KEY, firstname VARCHAR(50), lastname VARCHAR(50), hourlypay DECIMAL(5, 2), hiredate DATE ); RENAME TABLE employees TO workers; DROP TABLE employees; ALTER TABLE employees ADD phonenumber VARCHAR(15); ALTER TABLE employees RENAME COLUMN phonenumber TO email; ALTER TABLE employees MODIFY COLUMN email VARCHAR(15); ALTER TABLE employees MODIFY email VARCHAR(100) AFTER lastname; ALTER TABLE employees MODIFY email VARCHAR(100) FIRST; ALTER TABLE employees DROP COLUMN email;