常用SQL语句学习整理增
insert into table_name (column_name1,column_name2) values (value1,value2)
删
delete from table_name where column_name=value
改
update table_name set column_name=value_new_1,column_name=value_new_2 where column_name=value_old
查
select top 10 * from table1 where column_name=XXX order by column_name desc
内连接
select table1.column1,table1.column2,table2.column1 from table1 inner join table2 on table1.column1=table2.column1
左外连接
select table1.column1,table2.column1,table1.column2 from table1 left join table2 on table1.column1=table2.column1
右外连接
select table1.column1,table1.column2,table2.column1 from table1 right join table1 on table.column1=table2.column1
全连接
select tabe1.column1,table1.column2,table2.column1 from table1 full join table2 on table.column1=table2.column1
包含
select * from table where column_name like 'X%'
select * from table where column_name like '%X'
select * from table where column_name like '%X%'
select * from table where column_name not like '%X%'