目录java
1:mysql经常使用语法练习
首先默认表数据以下:
2:查询语句(select)
select * from user //查询全部数据
select name,age from user //查询指定字段
select distinct address from user// 因为地址信息有深圳,河南相同。查询结果为去重复
select * from user LIMIT 3,2 //从第3行开始查询2条数据。 查询结果是id是4,5的数据
3:排序语句(order by)
select * from user ORDER BY age //默认asc是a-z 数字1-9 升序,此处显示结果是1991-2020
select * from user ORDER BY age desc//desc是z-a,9-1 降序 此处显示结果是2020-1991
select * from user ORDER BY age desc,name //首先age降序2020-1991,而后name升序a-z
4:单一过滤语句(where)
//单一条件过滤语句
select * from user where name='bb' //等于
select * from user where age='2013-03-02'//等于
select * from user where name <> 'bb' // 不等于 查询名字不等于bb的数据
select * from user where name != 'bb' // 不等于 查询名字不等于bb的数据
select * from user where age >'2013-03-02' //大于 适用于日期和数值类型
select * from user where age >='2013-03-02' //大于等于 适用于日期和数值类型
select * from user where age
select * from user where age <='2013-03-02' //小于等于 适用于日期和数值类型
select * from user where age BETWEEN '2013-03-02' AND '2020-03-02'//介于二者之间
select * from user where age is null //空值判断
select * from user where age is not null //非空判断
5:组合条件过滤语句(where + 操做符)
//组合条件过滤
select * from user where name='bb' and address='河南' //and 两个条件都需套知足
select * from user where name='bb' OR address=