0

summary of basic SQL

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

5th Jan 2017, 8:45 AM
Azure Li
Azure Li - avatar
1 Resposta
+ 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). )
5th Jan 2017, 9:50 AM
Azure Li
Azure Li - avatar