MySQL 常用查询语句总结

数据库SQL语句的使用 

关于MySQL常用的查询语句

一、查询数值型数据:
 SELECT * FROM tb_name WHERE sum > 100;
 查询谓词:>,=,<,<>,!=,!>,!<,=>,=<
 
二、查询字符串
 SELECT * FROM tb_stu  WHERE sname  =  '小张'
 SELECT * FROM tb_stu  WHERE sname like '张%'
 SELECT * FROM tb_stu  WHERE sname like '%程序员'
 SELECT * FROM tb_stu  WHERE sname like '%python%'
 
三、查询日期型数据
 SELECT * FROM tb_stu WHERE date = '2019-02-08'
 注:不同数据库对日期型数据存在差异: ：
 (1)MySQL:SELECT * from tb_name WHERE birthday = '2019-02-08'
 (2)SQL Server:SELECT * from tb_name WHERE birthday = '2019-02-08'
 (3)Access:SELECT * from tb_name WHERE birthday = #2019-02-08#
 
四、查询逻辑型数据
 SELECT * FROM tb_name WHERE type = 'T'
 SELECT * FROM tb_name WHERE type = 'F'
 逻辑运算符:and or not
 
五、查询非空数据
 SELECT *