Hi guys, Welcome to the Advanced Video Search Engine, and you are watching MySQL: How to create a TABLE. That video is uploaded by Bro Code at 2022-10-09T08:53:34-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [XfrgCK6BX5w]
| Name | MySQL: How to create a TABLE |
| Video Uploader | Video From Bro Code |
| Upload Date | This Video Uploaded At 09-10-2022 15:53:34 |
| Video Discription | #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 ( 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; XfrgCK6BX5w |
| Category | Education |
| Tags | MySQL table | MySQL tables | CREATE TABLE |
