basic.commands.md

1 - Basic SQL Commands

Create, Alter, Drop, Add, Update, Delete

---

Create Database

create database social_network;

Create Table

create table users(user_id int,first_name VARCHAR(100),last_name VARCHAR(100),email VARCHAR(255)); 

Update Table Add

alter table users add encrypted_password varchar(1000);

Delete a Column From The Table

Alter Table users Drop Column email;

Delete Table

Drop Table users;

Delete Database

Drop database social_network;

---

----->>> Example 1 - MovieTable