内容回顾(数据的增删改)/单表查询
一.内容回顾
1.SQL语句中的DML语言来实现数据的操作
(1).使用insert实现数据的插入
(2).update实现数据的更新
(3).使用delete实现数据的删除
(4).使用select查询数据
2.插入数据(INSERT)
(1).插入完整数据(顺序插入)
语法一:insert into 表名(字段1,字段2,字段3...) values (值1,值2,值3...);
语法二:insert into 表名 values (值1,值2,值3...);
(2).指定字段插入数据
语法:insert into 表名(字段1,字段2,字段3...) values (值1,值2,值3...);
(3).插入多条记录
语法:insert into 表名 values (值1,值2,值3...), (值1,值2,值3...), (值1,值2,值3...);
(4).插入查询结果
语法:insert into 表名(字段1,字段2,字段3...) select (字段1,字段2,字段3...) from 表2 where ...;
3.更新数据UPDATE
语法:update 表名 set 字段1 = 值1, 字段2 = 值2, where condition;
示例:update mysql.user set password = password("123") where user = "root" and host = "localhost";
4.删除数据DELETE
语法:delete from 表名 where condition;
示例:delete from mysql.user where password = "";
二.单表查询
1.语法
1.表单查询的语法 select 字段1,字段2.. from 表名 where 条件 group by field having 筛选 order by field limit 限制条数 2.关键字的执行优先级(重点) (1).重点中的重点 from 找到表 where 拿到where指定的约束条件,去文件/表中取出一条条记录 group by 将取出的一条条记录进行分组group by,如果没有group by,则整体作为一组 having 将分组的结果进行having过滤 select 执行select distinct 去重 order by 将结果按条件排序:order by limit 限制结果的显示条数
2.创建公司员工表,表的字段和数据类型
company.employee 员工id id int 姓名 name varchar 性别 sex enum 年龄 age int 入职日期 hire_date date 岗位 post varchar 职位描述 post_comment varchar 薪水 salary double 办公室 office int 部门编号 depart_id int
3.创建员工表,并插入记录
#创建表,设置字段的约束条件 mysql> create table employee( -> id int primary key auto_increment, -> name varchar(20) not null, -> sex enum("male","female") not null default "male", -> age int(3) unsigned not null default 28, -> hire_date date not null, -> post varchar(50), -> post_comment varchar(100), -> salary double(15,2), -> office int, #一个部门一个屋 -> depart_id int -> ); Query OK, 0 rows affected (0.27 sec) #查看表结构 mysql> desc employee; +--------------+-----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+-----------------------+------+-----+---------+----------------+ | id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(20) | NO | | NULL | | | sex | enum('male','female') | NO | | male | | | age | int(3) unsigned | NO | | 28 | | | hire_date | date | NO | | NULL | | | post | varchar(50) | YES | | NULL | | | post_comment | varchar(100) | YES | | NULL | | | salary | double(15,2) | YES | | NULL | | | office | int(11) | YES | | NULL | | | depart_id | int(11) | YES | | NULL | | +--------------+-----------------------+------+-----+---------+----------------+ 10 rows in set (0.01 sec) #插入记录 #三个部门:教师,销售,运营 mysql> insert into employee(name, sex, age, hire_date, post, salary, office, depart_id) values -> ('娃哈哈','male',18,'20170301','幼儿园园长',7300.33,401,1), #以下是教学部 -> ('乳娃娃','male',78,'20150302','teacher',1000000.31,401,1), -> ('爽歪歪','male',81,'20130305','teacher',8300,401,1), -> ('冰红茶','male',73,'20140701','teacher',3500,401,1), -> ('绿茶','male',28,'20121101','teacher',2100,401,1), -> ('抹茶','female',18,'20110211','teacher',9000,401,1), -> ('花茶','male',18,'19000301','teacher',30000,401,1), -> ('黑茶','male',48,'20101111','teacher',10000,401,1), -> -> ('呵呵','female',48,'20150311','sale',3000.13,402,2),#以下是销售部门 -> ('嘿嘿','female',38,'20101101','sale',2000.35,402,2), -> ('哈哈','female',18,'20110312','sale',1000.37,402,2), -> ('哼哼','female',18,'20160513','sale',3000.29,402,2), -> ('嗯嗯','female',28,'20170127','sale',4000.33,402,2), -> -> ('青铜','male',28,'20160311','operation',10000.13,403,3), #以下是运营部门 -> ('白银','male',18,'19970312','operation',20000,403,3), -> ('黄金','female',18,'20130311','operation',19000,403,3), -> ('铂金','male',18,'20150411','operation',18000,403,3), -> ('钻石','female',18,'20140512','operation',17000,403,3) -> ; Query OK, 18 rows affected (0.09 sec) Records: 18 Duplicates: 0 Warnings: 0 #查看表 mysql> select * from employee; +----+-----------+--------+-----+------------+-----------------+--------------+------------+--------+-----------+ | id | name | sex | age | hire_date | post | post_comment | salary | office | depart_id | +----+-----------+--------+-----+------------+-----------------+--------------+------------+--------+-----------+ | 1 | 娃哈哈 | male | 18 | 2017-03-01 | 幼儿园园长 | NULL | 7300.33 | 401 | 1 | | 2 | 乳娃娃 | male | 78 | 2015-03-02 | teacher | NULL | 1000000.31 | 401 | 1 | | 3 | 爽歪歪 | male | 81 | 2013-03-05 | teacher | NULL | 8300.00 | 401 | 1 | | 4 | 冰红茶 | male | 73 | 2014-07-01 | teacher | NULL | 3500.00 | 401 | 1 | | 5 | 绿茶 | male | 28 | 2012-11-01 | teacher | NULL | 2100.00 | 401 | 1 | | 6 | 抹茶 | female | 18 | 2011-02-11 | teacher | NULL | 9000.00 | 401 | 1 | | 7 | 花茶 | male | 18 | 1900-03-01 | teacher | NULL | 30000.00 | 401 | 1 | | 8 | 黑茶 | male | 48 | 2010-11-11 | teacher | NULL | 10000.00 | 401 | 1 | | 9 | 呵呵 | female | 48 | 2015-03-11 | sale | NULL | 3000.13 | 402 | 2 | | 10 | 嘿嘿 | female | 38 | 2010-11-01 | sale | NULL | 2000.35 | 402 | 2 | | 11 | 哈哈 | female | 18 | 2011-03-12 | sale | NULL | 1000.37 | 402 | 2 | | 12 | 哼哼 | female | 18 | 2016-05-13 | sale | NULL | 3000.29 | 402 | 2 | | 13 | 嗯嗯 | female | 28 | 2017-01-27 | sale | NULL | 4000.33 | 402 | 2 | | 14 | 青铜 | male | 28 | 2016-03-11 | operation | NULL | 10000.13 | 403 | 3 | | 15 | 白银 | male | 18 | 1997-03-12 | operation | NULL | 20000.00 | 403 | 3 | | 16 | 黄金 | female | 18 | 2013-03-11 | operation | NULL | 19000.00 | 403 | 3 | | 17 | 铂金 | male | 18 | 2015-04-11 | operation | NULL | 18000.00 | 403 | 3 | | 18 | 钻石 | female | 18 | 2014-05-12 | operation | NULL | 17000.00 | 403 | 3 | +----+-----------+--------+-----+------------+-----------------+--------------+------------+--------+-----------+ 18 rows in set (0.00 sec)
(1).where约束
where子句中可以使用 1.比较运算符:>, <, >=, <=, <>, != 2.between 80 and 100:值在80到100之间 3.in(80,90,100)值是10或20或30 4.like "xiaohuapattern": pattern可以是%或者_; %表示任意多字符, _表示一个字符 5.逻辑运算符:在多个条件直接可以使用逻辑运算符 and or not
(2).验证
#1.单条件查询 mysql> select id,emp_name from employee where id > 5; ERROR 1054 (42S22): Unknown column 'emp_name' in 'field list' mysql> select id,name from employee where id > 5; +----+--------+ | id | name | +----+--------+ | 6 | 抹茶 | | 7 | 花茶 | | 8 | 黑茶 | | 9 | 呵呵 | | 10 | 嘿嘿 | | 11 | 哈哈 | | 12 | 哼哼 | | 13 | 嗯嗯 | | 14 | 青铜 | | 15 | 白银 | | 16 | 黄金 | | 17 | 铂金 | | 18 | 钻石 | +----+--------+ 13 rows in set (0.00 sec) #2.多条件查询 mysql> select name from employee where post = "teacher" and salary > 10000; +-----------+ | name | +-----------+ | 乳娃娃 | | 花茶 | +-----------+ 2 rows in set (0.00 sec) #关键字查询 BETWEEN AND mysql> select name,salary from employee where salary between 1000 and 20000; +-----------+----------+ | name | salary | +-----------+----------+ | 娃哈哈 | 7300.33 | | 爽歪歪 | 8300.00 | | 冰红茶 | 3500.00 | | 绿茶 | 2100.00 | | 抹茶 | 9000.00 | | 黑茶 | 10000.00 | | 呵呵 | 3000.13 | | 嘿嘿 | 2000.35 | | 哈哈 | 1000.37 | | 哼哼 | 3000.29 | | 嗯嗯 | 4000.33 | | 青铜 | 10000.13 | | 白银 | 20000.00 | | 黄金 | 19000.00 | | 铂金 | 18000.00 | | 钻石 | 17000.00 | +-----------+----------+ 16 rows in set (0.00 sec) mysql> select name,salary from employee where salary between 10000 and 20000; +--------+----------+ | name | salary | +--------+----------+ | 黑茶 | 10000.00 | | 青铜 | 10000.13 | | 白银 | 20000.00 | | 黄金 | 19000.00 | | 铂金 | 18000.00 | | 钻石 | 17000.00 | +--------+----------+ 6 rows in set (0.00 sec) mysql> select name,salary from employee where salary not between 10000 and 20000; +-----------+------------+ | name | salary | +-----------+------------+ | 娃哈哈 | 7300.33 | | 乳娃娃 | 1000000.31 | | 爽歪歪 | 8300.00 | | 冰红茶 | 3500.00 | | 绿茶 | 2100.00 | | 抹茶 | 9000.00 | | 花茶 | 30000.00 | | 呵呵 | 3000.13 | | 嘿嘿 | 2000.35 | | 哈哈 | 1000.37 | | 哼哼 | 3000.29 | | 嗯嗯 | 4000.33 | +-----------+------------+ 12 rows in set (0.00 sec) #注意""是空字符串,不是null mysql> select name,post_comment from employee where post_comment = ""; #无结果 Empty set (0.00 sec) #执行: mysql> update employee set post_comment = "" where id = 2; Query OK, 1 row affected (0.08 sec) Rows matched: 1 Changed: 1 Warnings: 0 #再执行,有结果 mysql> select name,post_comment from employee where post_comment = ""; +-----------+--------------+ | name | post_comment | +-----------+--------------+ | 乳娃娃 | | +-----------+--------------+ 1 row in set (0.00 sec) #关键字IN集合查询 mysql> select name,salary from employee where salary = 3000 or salary = 3500 or salary = 4000 or salary = 9000; +-----------+---------+ | name | salary | +-----------+---------+ | 冰红茶 | 3500.00 | | 抹茶 | 9000.00 | +-----------+---------+ 2 rows in set (0.00 sec) mysql> select name,salary from employee where salary in(3000,3500,4000,9000); +-----------+---------+ | name | salary | +-----------+---------+ | 冰红茶 | 3500.00 | | 抹茶 | 9000.00 | +-----------+---------+ 2 rows in set (0.00 sec) mysql> select name,salary from employee where salary not in(3000,3500,4000,9000); +-----------+------------+ | name | salary | +-----------+------------+ | 娃哈哈 | 7300.33 | | 乳娃娃 | 1000000.31 | | 爽歪歪 | 8300.00 | | 绿茶 | 2100.00 | | 花茶 | 30000.00 | | 黑茶 | 10000.00 | | 呵呵 | 3000.13 | | 嘿嘿 | 2000.35 | | 哈哈 | 1000.37 | | 哼哼 | 3000.29 | | 嗯嗯 | 4000.33 | | 青铜 | 10000.13 | | 白银 | 20000.00 | | 黄金 | 19000.00 | | 铂金 | 18000.00 | | 钻石 | 17000.00 | +-----------+------------+ 16 rows in set (0.00 sec) #关键字LIKE模糊查询 mysql> select * from employee where name like "%茶"; +----+-----------+--------+-----+------------+---------+--------------+----------+--------+-----------+ | id | name | sex | age | hire_date | post | post_comment | salary | office | depart_id | +----+-----------+--------+-----+------------+---------+--------------+----------+--------+-----------+ | 4 | 冰红茶 | male | 73 | 2014-07-01 | teacher | NULL | 3500.00 | 401 | 1 | | 5 | 绿茶 | male | 28 | 2012-11-01 | teacher | NULL | 2100.00 | 401 | 1 | | 6 | 抹茶 | female | 18 | 2011-02-11 | teacher | NULL | 9000.00 | 401 | 1 | | 7 | 花茶 | male | 18 | 1900-03-01 | teacher | NULL | 30000.00 | 401 | 1 | | 8 | 黑茶 | male | 48 | 2010-11-11 | teacher | NULL | 10000.00 | 401 | 1 | +----+-----------+--------+-----+------------+---------+--------------+----------+--------+-----------+ 5 rows in set (0.00 sec) mysql> select age from employee where name like "_茶"; +-----+ | age | +-----+ | 28 | | 18 | | 18 | | 48 | +-----+ 4 rows in set (0.00 sec)
4.group by 分组查询
1.首先明确一点:分组发生在where之后,即分组是基于where之后得到的记录而进行的 2.分组指的是:将所有记录按照某个相同字段进行分类,比如针对员工信息表的职位分组,或者按照性别进行分组等 3.为何要分组: 取每个部门的最高工资 取每个部门的员工数 取男人数和女人数 小窍门:"每"这个字后面的字段,就是我们分组的依据 4.大前提:可以按照任意字段分组,但是分组完毕后,比如group by post,只能查看post字段,如果想查看组内信息,需要借助于聚合函数
当执行以下sql语句的时候,是以post字段查询了组中的第一条数据,没有任何意义,因为我们现在想查出当前组的多条记录
mysql> select * from employee group by post; +----+-----------+--------+-----+------------+-----------------+--------------+------------+--------+-----------+ | id | name | sex | age | hire_date | post | post_comment | salary | office | depart_id | +----+-----------+--------+-----+------------+-----------------+--------------+------------+--------+-----------+ | 14 | 青铜 | male | 28 | 2016-03-11 | operation | NULL | 10000.13 | 403 | 3 | | 9 | 呵呵 | female | 48 | 2015-03-11 | sale | NULL | 3000.13 | 402 | 2 | | 2 | 乳娃娃 | male | 78 | 2015-03-02 | teacher | | 1000000.31 | 401 | 1 | | 1 | 娃哈哈 | male | 18 | 2017-03-01 | 幼儿园园长 | NULL | 7300.33 | 401 | 1 | +----+-----------+--------+-----+------------+-----------------+--------------+------------+--------+-----------+ 4 rows in set (0.00 sec) #由于没有设置ONLY_FULL_GROUP_BY,于是也可以有结果，默认都是组内的第一条记录，但其实这是没有意义的 #想分组就必须要在全局的SQL的模式设置为ONLY_FULL_GROUP_BY,把这段英文添加到数据库安装地址中的my.ini配置文件中的sql_mode句段后 #查看MySQL5.7默认的sql_mode如下: mysql> select @@global.sql_mode; +---------------------------------------------------------------+ | @@global.sql_mode | +---------------------------------------------------------------+ | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION | +---------------------------------------------------------------+ 1 row in set (0.00 sec) #设置成功后必须退出客户端重启服务端
继续验证通过group by分组之后，只能查看当前字段,如果想查看组内信息，需要借助于聚合函数
mysql> select * from employee group by post; #报错 ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db7.employee.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by mysql> select post from employee group by post; +-----------------+ | post | +-----------------+ | operation | | sale | | teacher | | 幼儿园园长 | +-----------------+ 4 rows in set (0.00 sec)
5.聚合函数
max()求最大值 min()求最小值 avg()求平均值 sum()求和 count()求总个数 #强调：聚合函数聚合的是组的内容，若是没有分组，则默认一组 # 每个部门有多少个员工 select post,count(id) from employee group by post; # 每个部门的最高薪水 select post,max(salary) from employee group by post; # 每个部门的最低薪水 select post,min(salary) from employee group by post; # 每个部门的平均薪水 select post,avg(salary) from employee group by post; # 每个部门的所有薪水 select post,sum(age) from employee group by post;
6.having过滤
HAVING与WHERE不一样的地方在于
#having后面的字段只能是分组(group by之后的字段) #！！！执行优先级从高到低：where > group by > having #1. Where 发生在分组group by之前，因而Where中可以有任意字段，但是绝对不能使用聚合函数。 #2. Having发生在分组group by之后，因而Having中可以使用分组的字段，可以直接取到其他字段,可以使用聚合函数
mysql> select post,group_concat(name) from emp having salary > 10000; ERROR 1054 (42S22): Unknown column 'post' in 'field list' mysql> select * from employee where salary > 100000; +----+-----------+------+-----+------------+---------+--------------+------------+--------+-----------+ | id | name | sex | age | hire_date | post | post_comment | salary | office | depart_id | +----+-----------+------+-----+------------+---------+--------------+------------+--------+-----------+ | 2 | 乳娃娃 | male | 78 | 2015-03-02 | teacher | | 1000000.31 | 401 | 1 | +----+-----------+------+-----+------------+---------+--------------+------------+--------+-----------+ 1 row in set (0.00 sec) mysql> select * from employee having salary > 1000000; +----+-----------+------+-----+------------+---------+--------------+------------+--------+-----------+ | id | name | sex | age | hire_date | post | post_comment | salary | office | depart_id | +----+-----------+------+-----+------------+---------+--------------+------------+--------+-----------+ | 2 | 乳娃娃 | male | 78 | 2015-03-02 | teacher | | 1000000.31 | 401 | 1 | +----+-----------+------+-----+------------+---------+--------------+------------+--------+-----------+ 1 row in set (0.00 sec) #必须使用group by才能使用group_concat()函数,将所有的name值连接 mysql> select post,group_concat(name) from emp group by post having salary > 10000; ERROR 1054 (42S22): Unknown column 'post' in 'field list'
1.查询各岗位内包含的员工个数小于2的岗位名、岗位内包含员工名字、个数 select post,group_concat(name),count(1) from employee group by post having count(1) < 2; 2. 查询各岗位平均薪资大于10000的岗位名、平均工资 select * from employee where salary not in (select avg(salary) as A from employee group by post having A > 10000); select post,avg(salary) as A from employee group by post having A > 10000 3. 查询各岗位平均薪资大于10000且小于20000的岗位名、平均工资 select post,avg(salary) from employee group by post having avg(salary) between 10000 and 20000;
7.order by 查询排序
按单列排序 select * from employee order by age; select * from employee order by age ASC; select * from employee order by age DESC; 按多列排序:先按照age升序排序,,如果年纪相同,则id降序 select * from employee order by age ASC, id DESC;
mysql> select * from employee order by age ASC, id DESC; +----+-----------+--------+-----+------------+-----------------+--------------+------------+--------+-----------+ | id | name | sex | age | hire_date | post | post_comment | salary | office | depart_id | +----+-----------+--------+-----+------------+-----------------+--------------+------------+--------+-----------+ | 18 | 钻石 | female | 18 | 2014-05-12 | operation | NULL | 17000.00 | 403 | 3 | | 17 | 铂金 | male | 18 | 2015-04-11 | operation | NULL | 18000.00 | 403 | 3 | | 16 | 黄金 | female | 18 | 2013-03-11 | operation | NULL | 19000.00 | 403 | 3 | | 15 | 白银 | male | 18 | 1997-03-12 | operation | NULL | 20000.00 | 403 | 3 | | 12 | 哼哼 | female | 18 | 2016-05-13 | sale | NULL | 3000.29 | 402 | 2 | | 11 | 哈哈 | female | 18 | 2011-03-12 | sale | NULL | 1000.37 | 402 | 2 | | 7 | 花茶 | male | 18 | 1900-03-01 | teacher | NULL | 30000.00 | 401 | 1 | | 6 | 抹茶 | female | 18 | 2011-02-11 | teacher | NULL | 9000.00 | 401 | 1 | | 1 | 娃哈哈 | male | 18 | 2017-03-01 | 幼儿园园长 | NULL | 7300.33 | 401 | 1 | | 14 | 青铜 | male | 28 | 2016-03-11 | operation | NULL | 10000.13 | 403 | 3 | | 13 | 嗯嗯 | female | 28 | 2017-01-27 | sale | NULL | 4000.33 | 402 | 2 | | 5 | 绿茶 | male | 28 | 2012-11-01 | teacher | NULL | 2100.00 | 401 | 1 | | 10 | 嘿嘿 | female | 38 | 2010-11-01 | sale | NULL | 2000.35 | 402 | 2 | | 9 | 呵呵 | female | 48 | 2015-03-11 | sale | NULL | 3000.13 | 402 | 2 | | 8 | 黑茶 | male | 48 | 2010-11-11 | teacher | NULL | 10000.00 | 401 | 1 | | 4 | 冰红茶 | male | 73 | 2014-07-01 | teacher | NULL | 3500.00 | 401 | 1 | | 2 | 乳娃娃 | male | 78 | 2015-03-02 | teacher | | 1000000.31 | 401 | 1 | | 3 | 爽歪歪 | male | 81 | 2013-03-05 | teacher | NULL | 8300.00 | 401 | 1 | +----+-----------+--------+-----+------------+-----------------+--------------+------------+--------+-----------+ 18 rows in set (0.01 sec)
8.limit限制查询的记录数
示例: select * from employee order by salary DESC LIMIT 3; #默认初识位置为0 select * from employee order by salary DESC LIMIT 0,5; #从第0开始,即先查询出第一条,然后包含这一条在内往后查5条 select * from employee order by salary DESC LIMT 5,5; #从第5开始,即先查询出第6条,然后包含这一条在内往后查5条
#分页显示,每页5条 #第一页数据 mysql> select * from employee limit 0,5; +----+-----------+------+-----+------------+-----------------+--------------+------------+--------+-----------+ | id | name | sex | age | hire_date | post | post_comment | salary | office | depart_id | +----+-----------+------+-----+------------+-----------------+--------------+------------+--------+-----------+ | 1 | 娃哈哈 | male | 18 | 2017-03-01 | 幼儿园园长 | NULL | 7300.33 | 401 | 1 | | 2 | 乳娃娃 | male | 78 | 2015-03-02 | teacher | | 1000000.31 | 401 | 1 | | 3 | 爽歪歪 | male | 81 | 2013-03-05 | teacher | NULL | 8300.00 | 401 | 1 | | 4 | 冰红茶 | male | 73 | 2014-07-01 | teacher | NULL | 3500.00 | 401 | 1 | | 5 | 绿茶 | male | 28 | 2012-11-01 | teacher | NULL | 2100.00 | 401 | 1 | +----+-----------+------+-----+------------+-----------------+--------------+------------+--------+-----------+ 5 rows in set (0.00 sec) #第二页数据 mysql> select * from employee limit 5,5; +----+--------+--------+-----+------------+---------+--------------+----------+--------+-----------+ | id | name | sex | age | hire_date | post | post_comment | salary | office | depart_id | +----+--------+--------+-----+------------+---------+--------------+----------+--------+-----------+ | 6 | 抹茶 | female | 18 | 2011-02-11 | teacher | NULL | 9000.00 | 401 | 1 | | 7 | 花茶 | male | 18 | 1900-03-01 | teacher | NULL | 30000.00 | 401 | 1 | | 8 | 黑茶 | male | 48 | 2010-11-11 | teacher | NULL | 10000.00 | 401 | 1 | | 9 | 呵呵 | female | 48 | 2015-03-11 | sale | NULL | 3000.13 | 402 | 2 | | 10 | 嘿嘿 | female | 38 | 2010-11-01 | sale | NULL | 2000.35 | 402 | 2 | +----+--------+--------+-----+------------+---------+--------------+----------+--------+-----------+ 5 rows in set (0.00 sec) #第三页数据 mysql> select * from employee limit 10,5; +----+--------+--------+-----+------------+-----------+--------------+----------+--------+-----------+ | id | name | sex | age | hire_date | post | post_comment | salary | office | depart_id | +----+--------+--------+-----+------------+-----------+--------------+----------+--------+-----------+ | 11 | 哈哈 | female | 18 | 2011-03-12 | sale | NULL | 1000.37 | 402 | 2 | | 12 | 哼哼 | female | 18 | 2016-05-13 | sale | NULL | 3000.29 | 402 | 2 | | 13 | 嗯嗯 | female | 28 | 2017-01-27 | sale | NULL | 4000.33 | 402 | 2 | | 14 | 青铜 | male | 28 | 2016-03-11 | operation | NULL | 10000.13 | 403 | 3 | | 15 | 白银 | male | 18 | 1997-03-12 | operation | NULL | 20000.00 | 403 | 3 | +----+--------+--------+-----+------------+-----------+--------------+----------+--------+-----------+ 5 rows in set (0.00 sec)
浙公网安备 33010602011771号