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;
Watch video MySQL - Create, Alter and Delete Tables (Create Table, Alter Table, Drop Table ) online without registration, duration hours minute second in high quality. This video was added by user Eli the Computer Guy 20 November 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6,049 once and liked it 186 people.