1.select 语句
select number,name from table1;//从“table1”中选择“number”,“name”两行；
select * from table1;//从“table1”中选择所有行；
select * from table1 where name = "麦当劳麦乐送";//从“table1”中选择name 为“麦当劳麦乐送”的纪录；
select * from table1 where name like "麦%";//模糊查询：从“table1”中选择name以“麦”开始的纪录（“%麦%”；”%麦“）；
select * from table1 where number = 4008517517 or name = "必胜客宅急送";//从“table1”中选择number为“4008517517”或者name为“必胜客宅急送”的记录；
select * from table1 where number = 4008517517 and name = "麦当劳麦乐送";//从“table1”中选择number为“4008517517”并且name为“必胜客宅急送”的记录；
select distinct number, name from table1 ;//从“table1”中选择number或者name均不相同的纪录（number或者name某一项相同不会被排除）；
2.统计函数
select sum(Sales) from Store_Information；//所有 Sales 栏位的总合
select count(store_name) from Store_Information;//总共多少个Store_Information
select count(distinct store_name) from Store_Information where store_name is not NULL;//去重并且不为null(空串照样统计)Store_Information总共多少个
select sum( Sales) ,store_name from Store_Information where store_name is not NULL and store_name!=" " group by store_name;//统计每个有店名的店的销售额
select sum( Sales) ,store_name from Store_Information group by store_name having sum(Sales) >=300；//统计销售额大于等于300的店
select sum( S1.Sales) StoreSales,S1.store_name StoreName from Store_Information S1 group by S1.store_name having sum(Sales) >=300；//别名机制
3.insert 语句
insert into table1 (number,name) values (4008823823,"真功夫");
