文本用单引号环绕,
数值字段不加引号。
select distinct:
select distinct column1,column2 from table1;
– 从table1中取出column1,column2中所有不重复项。
while:between like in
select column1 from table1 while sex=‘man’
and,or:
order by:asc desc 排序 默认asc 升序
insert into:插入, 带表栏目指定插入,不带表栏要全部数据
update:修改, update table1 set grand=50 while class=‘一班’;
delete:删除 ,delete from table1 while…;