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;