澳门金沙vip几个简单的基本的sql语句

说明:几个简单的基本的sql语句 选择:select * from table1 where 范围
插入:insert into table1(field1,field2) values(value1,value2)
删除:delete from table1 where 范围 更新:update table1 set
field1=value1 where 范围 查找:select * from table1 where field1 like
‘%value1%’ —like的语法很精妙,查资料! 排序:select *澳门金沙vip, from table1
order by field1,field2 [desc] 总数:select count * as totalcount from
table1 求和:select sum(field1) as sumvalue from table1 平均:select
avg(field1) as avgvalue from table1 最大:select max(field1) as maxvalue
from table1 最小:select min(field1) as minvalue from table1

选择:select * from table1 where 范围

注释:从table1表中选择(select)某个范围内的数据,*代表所有的内容。本句SQL命令重点在于——select
列 from 表 where 范围。

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

注释:插入(insert)到table1表中field1和field2列数据值(values)value1和value2。其中table1是表名、field1和field2是列名、value1和value2是数据。本句需要记住的是insert
into 表(列)values(数值)。