MySQL: How to create a TABLE

#sql #MySQL #table https://www.seevid.ir/fa/w/XfrgCK6BX5w Intro https://www.seevid.ir/fa/w/XfrgCK6BX5w CREATE TABLE https://www.seevid.ir/fa/w/XfrgCK6BX5w SELECT * FROM TABLE https://www.seevid.ir/fa/w/XfrgCK6BX5w RENAME TABLE https://www.seevid.ir/fa/w/XfrgCK6BX5w DROP TABLE https://www.seevid.ir/fa/w/XfrgCK6BX5w Add a column https://www.seevid.ir/fa/w/XfrgCK6BX5w Rename a column https://www.seevid.ir/fa/w/XfrgCK6BX5w Modify a column https://www.seevid.ir/fa/w/XfrgCK6BX5w Change column position AFTER https://www.seevid.ir/fa/w/XfrgCK6BX5w Change column position FIRST https://www.seevid.ir/fa/w/XfrgCK6BX5w Drop a column https://www.seevid.ir/fa/w/XfrgCK6BX5w Conclusion CREATE TABLE employees ( employee_id int PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), hourly_pay DECIMAL(5, 2), hire_date DATE ); RENAME TABLE employees TO workers; DROP TABLE employees; ALTER TABLE employees ADD phone_number VARCHAR(15); ALTER TABLE employees RENAME COLUMN phone_number TO email; ALTER TABLE employees MODIFY COLUMN email VARCHAR(15); ALTER TABLE employees MODIFY email VARCHAR(100) AFTER last_name; ALTER TABLE employees MODIFY email VARCHAR(100) FIRST; ALTER TABLE employees DROP COLUMN email;

• #education
• #mysql_table
• #mysql_tables
• #create_table