mysql教材第四章课后题答案_Mysql第四章：mysql语法练习

目录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=