summary of basic SQL

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). )