summary of basic SQL | Sololearn: Learn to code for FREE!

0

summary of basic SQL

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

sql

1/5/2017 8:45:15 AM

Azure Li

1 Answer

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