MySQL - Create, Alter and Delete Tables (Create Table, Alter Table, Drop Table )

Find code and diagrams at: https://www.EliTheComputerGuy.com

Tables are the building blocks of Databases. They store the records for the Database are are easy to create, alter and delete.

Use database; – Enter Database Select database(); – Shows what Database you are currently in Show tables; – Shows Tables in Database Create a Table Example:

Create table users( user_id INT Auto_INCREMENT PRIMARY KEY, Name TEXT, Age INT, Bio TEXT ); Desc tableName; – Shows Column information for Table Alter Table Example:

alter table users add gender text;

alter table users drop gender; ... https://www.youtube.com/watch?v=-JzdTyBs3TU