常用的sql语句

增加一个列

Alter table tabname add column col type

?

插入：insert into table1(field1,field2) values(value1,value2)

?

删除：delete from table1 where 范围

?

更新：update table1 set field1=value1 where 范围

?

排序：select * from table1 order by field1,field2 [desc]