summary of basic SQL

Question

All you need to know about this course, please add more if you guys find others

Answer 1

Union (union all) -- combine rows from different tables
Join (inner, left, right) -- combine columns from different tabls

Insect into Values(), Delete From-- add or delete rows in table
Update - Set -- update colunms' value
Alter Table - Add, Drop, Rename --- add or delete or rename colunms

Creat Table tablename
( name varchar(50)
ID int
Primary KEY(ID). )