mysql基础语句

1.       创建（删除）数据库：create（drop） database dbname

2.       根据已有表创建新表：create table ta_test like tab_old

3.       删除表 drop table tb_test

4.       选择：select * from tb_tet where 范围

5.       插入：insert into tb_test (field1,field2) values (value1,value2);

6.       删除: delete from tb_test where 范围

7.       更新：update tb_test set field1 = value1 where 范围

8.       查找：select * from tb_test where field1 like ‘%value1%’

9.       排序：select * from tb_test order by filed1,field2 desc

10.   总数：select count as totalCount from tb_test

11.   求和：select sum(field1) as sumvalue from tb_test

12.   平均：select avg(fileld1) as avgvalue from tb_test

13.   最大：select max(field1) as maxvalue from tb_test

14.   最小：select min(field1) as minvalue from tb_test

15.   Union运算符：通过组合其他两个表并消除表中的重复行派生出一个新表

16.   Except运算符：所有在table1中但不在table2中的行并消除所有重复行而派生出一个新表

17.   Intersect运算符：只包括table1和table2中都有的行并消除重复行而派生出一个新表

18.  Group by

19.  between :select * from tb_testwhere time (not) between time1 and time2

20.  in: select * from tb_test wherea in (‘value1’,value2’’);

21.  前10条记录：select  top 10 * from tabletb_test where 范围