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


summary of basic SQL

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


1/5/2017 8:45:15 AM

Azure Li

1 Answer

New Answer


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