1.create table rxqtest (sno int(10),name varchar(20))
2.insert into rxqtest(sno,name)values(1,‘rxq‘)
3.select * from rxqtest
4.update rxqtest set sno =2 where sno =1
5.delete from rxqtest where snp =2
6.create index rxq_index ON rxqtest(sno)
7.show index from rxqtest
8.select A.* from A left join/inner join /right join B on A.id =B.id
9.group by 分组 order by 排序
10.case colum when value1 then value2 else value3 end
11.delete drop truncate
12.in not in exits not exits distinct
13.count sum avg
14.select sno,name from rxqtest group by sno,name //根据两个条件分组