1、select：条件查询、模糊查询、子查询，分组统计；
select * from table where column_name = ？ select * from table where column_name like ' ' select * from table where column_name in select Customer,SUM(OrderPrice) FROM Orders GROUP BY Customer #分组统计 select Customer,SUM(OrderPrice) FROM Orders order by Customer #排序2、insert； insert into table_name values(‘1’,’2’) insert into table_name values(‘1’,’2’)，(‘3’,’4’) insert into table_name select ‘1’,’2’ union select ‘1’,’2’ –多条
3、update：带条件更新指定记录； update table_name set column_name =” where column_name=” 4、delete； delect from table_name where column_name = ”删除行 alter table add column #增加列 5、存储过程创建、调用；
6、常用函数； 7、主键和索引 8、inner连接 9、创建视图 create view view_name as select * from table
