MySQL语句
# drop databases if exists rweb_sql;
create database rweb_sql character set utf8;
use rweb_sql;
#
DROP TABLE IF EXISTS tb_emp1;
CREATE TABLE tb_emp1(
id INT(32) PRIMARY KEY,
name VARCHAR(25) NOT NULL,
deptId VARCHAR(32) NOT NULL,
salary FLOAT
);
#
DROP TABLE IF EXISTS study_1;
CREATE TABLE study_1(
f_id CHAR(10) NOT NULL,
s_id INT NOT NULL,
f_name char(255) NOT NULL,
f_price DECIMAL(8,2) NOT NULL,
f_type char(100) NOT NULL,
PRIMARY KEY(f_id)
);
INSERT INTO study_1(f_id,s_id,f_name,f_price,f_type) VALUES
('001' , 101 , '苹果' , 9.2,'fruit'),
('002' , 101 , '黑莓' , 10.2,'fruit'),
('003' , 102 , '橘子' , 3.2,'fruit'),
('004' , 103 , '香蕉' , 2.2,'fruit'),
('005' , 102 , '火龙果' , 6.3,'fruit'),
('006' , 102 , '葡萄' , 5.3,'fruit'),
('007' , 103 , '橙子' , 9.2,'fruit'),
('008' , 101 , '西瓜' , 7.2,'fruit'),
('009' , 104 , '香瓜' , 6.4,'fruit'),
('010' , 105 , '果粒橙' , 3,'drink'),
('011' , 105 , '乐橙' , 3,'drink'),
('012' , 105 , '开心果粒橙' , 3,'drink'),
('013' , 106 , '可口可乐' , 4,'drink'),
('014' , 107 , '百世可乐' , 4,'drink'),
('015' , 108 , '鸡尾酒' , 32,'wine'),
('016' , 109 , '合力葡萄酒' , 66,'wine'),
('017' , 109 , '飞悦葡萄酒' , 66,'wine'),
('018' , 110 , '开心葡萄酒' , 67,'wine')
;
DROP TABLE IF EXISTS study_2;
CREATE TABLE study_2(
p_id CHAR(10) NOT NULL,
f_id INT NOT NULL,
p_name VARCHAR(100) NOT NULL,
p_star int not null ,
PRIMARY KEY(p_id)
);
INSERT INTO study_2(p_id, f_id,p_name,p_star) VALUES
('p001' , 101 , 'D1生产厂家',3),
('p002' , 102 , 'D2生产厂家',4),
('p003' , 103 , 'D3生产厂家',3),
('p004' , 104 , 'D4生产厂家',5),
('p005' , 105 , 'D5生产厂家',5),
('p006' , 106 , 'D6生产厂家',2),
('p007' , 107 , 'D7生产厂家',2),
('p008' , 108 , 'D8生产厂家',3),
('p009' , 109 , 'D9生产厂家',4),
('p011' , 111 , 'D11生产厂家',2)
;
#
##-----------单表查询
select f_name,f_price from study_1 ;
##desc 降序 大到小,倒金字塔排序
select s_id,f_name,f_price from study_1 order by s_id desc;
##asc升序 默认 可以不写,金字塔排序
select s_id,f_name,f_price from study_1 order by s_id asc ;
select s_id,f_name,f_price from study_1 order by f_price desc;
select s_id,f_name,f_price from study_1 order by s_id desc ,f_price desc ;
select s_id,f_name,f_price from study_1 order by f_price desc,s_id desc ;
select f_name,f_price from study_1 where f_price between 6 and 9;
##聚合函数 sum count avg max min
select s_id ,count(*) as 根据s_id分组的总数 from study_1 group by s_id;
select s_id ,sum(f_price) as 根据s_id分组sum函数f_price函数体 from study_1 group by s_id;
select s_id ,avg(f_price) as 根据s_id分组求分组的f_price平均值 from study_1 group by s_id;
select max(f_price) as f_price最大值 from study_1;
select min(f_price) as f_price最大值 from study_1;
##错误示例 不能加f_name
##select f_name,max(f_price) as f_price最大值 from study_1;
select f_type,count(*) as 根据f_type分组的总数 from study_1 group by f_type having count(*)>3;
##查询s_id满足在(102,106,108)
select s_id,f_name from study_1
where s_id in (102,106,108);
select s_id ,count(*) as 求s_id满足条件的总数包括空值 from study_1 where s_id in (102,106,108)
group by s_id;
select s_id ,count(s_id) as 求s_id满足条件且值不为空总数 from study_1 where s_id in (102,106,108)
group by s_id;
select s_id ,sum(s_id) as 求s_id满足条件的和 from study_1 where s_id in (102,106,108)
group by s_id;
##错误示范 不能添加f_name
##select f_name, s_id ,count(*) as 根据s_id分组的总数 from study_1 where s_id in (102,106,108)
##group by s_id;
##-----------表连接查询
##左连接
select s_id as 生产厂家ID,f_name as 产品名称,f_price 产品价格 from study_1 as 产品列表
left join study_2 as
生产厂家 on 产品列表.s_id= 生产厂家.f_id;
##右连接
select s_id as 生产厂家ID,f_name as 产品名称,f_price 产品价格 from study_1 as 产品列表
right join study_2 as
生产厂家 on 产品列表.s_id= 生产厂家.f_id;
##内连接,inner可以不写
select s_id as 生产厂家ID,f_name as 产品名称,f_price 产品价格 from study_1 as 产品列表
join study_2 as
生产厂家 on 产品列表.s_id= 生产厂家.f_id;
### 生产厂家.p_star>3
select s_id as 生产厂家ID,f_name as 产品名称,f_price 产品价格
from study_1 as 产品列表
left join study_2 as
生产厂家 on 产品列表.s_id= 生产厂家.f_id
where 生产厂家.p_star>3;
## 根据f_type 获取 生产厂家.p_star>3的分组
select f_type as 产品类型, count(*) as 根据f_type分组的总数
from study_1 as 产品列表
left join study_2 as
生产厂家 on 产品列表.s_id= 生产厂家.f_id where 生产厂家.p_star>3
group by f_type;
## 根据f_type 获取 生产厂家.p_star>3的分组并且 分组数和大于3
select f_type as 产品类型, count(*) as 根据f_type分组的总数
from study_1 as 产品列表
left join study_2 as
生产厂家 on 产品列表.s_id= 生产厂家.f_id where 生产厂家.p_star>3
group by f_type having count(*)>3;
##-------子查询 in、 not in 、exists、 not exists、= 、!=
##根据生产厂家ID查询其f_id,再跟具f_id查询其f_name
select f_name as 产品名称
from study_1
where s_id in
(select f_id from study_2 where p_id='p002');
##多个字段
select f_id 产品id,s_id as 生产厂家p002对应的f_id ,f_name as 产品名称
from study_1 where s_id in
(select f_id from study_2 where p_id='p002');
##sum求和返回必然是一行数据,所以不能添加其他数据库查询字段
select s_id as 生产厂家p002对应的f_id ,sum(s_id) as 求s_id的sum和
from study_1 where s_id in
(select f_id from study_2 where p_id='p002');
##原因同sum
select s_id as 生产厂家p002对应的f_id ,count(s_id) as 求s_id的列数不包括null
from study_1 where s_id in
(select f_id from study_2 where p_id='p002');
## union 、union all
完整控制台输出
E:\soft-dev-workspace\IDEA201911\rwebserver\Rweb_sql.sql
-----------执行过程
mysql> select f_name,f_price from study_1 ;
+------------+---------+
| f_name | f_price |
+------------+---------+
| 苹果 | 9.20 |
| 黑莓 | 10.20 |
| 橘子 | 3.20 |
| 香蕉 | 2.20 |
| 火龙果 | 6.30 |
| 葡萄 | 5.30 |
| 橙子 | 9.20 |
| 西瓜 | 7.20 |
| 香瓜 | 6.40 |
| 果粒橙 | 3.00 |
| 乐橙 | 3.00 |
| 开心果粒橙 | 3.00 |
| 可口可乐 | 4.00 |
| 百世可乐 | 4.00 |
| 鸡尾酒 | 32.00 |
| 合力葡萄酒 | 66.00 |
| 飞悦葡萄酒 | 66.00 |
| 开心葡萄酒 | 67.00 |
+------------+---------+
18 rows in set (0.08 sec)
mysql> select * from study_1;
+------+------+------------+---------+--------+
| f_id | s_id | f_name | f_price | f_type |
+------+------+------------+---------+--------+
| 001 | 101 | 苹果 | 9.20 | fruit |
| 002 | 101 | 黑莓 | 10.20 | fruit |
| 003 | 102 | 橘子 | 3.20 | fruit |
| 004 | 103 | 香蕉 | 2.20 | fruit |
| 005 | 102 | 火龙果 | 6.30 | fruit |
| 006 | 102 | 葡萄 | 5.30 | fruit |
| 007 | 103 | 橙子 | 9.20 | fruit |
| 008 | 101 | 西瓜 | 7.20 | fruit |
| 009 | 104 | 香瓜 | 6.40 | fruit |
| 010 | 105 | 果粒橙 | 3.00 | drink |
| 011 | 105 | 乐橙 | 3.00 | drink |
| 012 | 105 | 开心果粒橙 | 3.00 | drink |
| 013 | 106 | 可口可乐 | 4.00 | drink |
| 014 | 107 | 百世可乐 | 4.00 | drink |
| 015 | 108 | 鸡尾酒 | 32.00 | wine |
| 016 | 109 | 合力葡萄酒 | 66.00 | wine |
| 017 | 109 | 飞悦葡萄酒 | 66.00 | wine |
| 018 | 110 | 开心葡萄酒 | 67.00 | wine |
+------+------+------------+---------+--------+
18 rows in set (0.10 sec)
mysql> select * from study_2;
+------+------+-------------+--------+
| p_id | f_id | p_name | p_star |
+------+------+-------------+--------+
| p001 | 101 | D1生产厂家 | 3 |
| p002 | 102 | D2生产厂家 | 4 |
| p003 | 103 | D3生产厂家 | 3 |
| p004 | 104 | D4生产厂家 | 5 |
| p005 | 105 | D5生产厂家 | 5 |
| p006 | 106 | D6生产厂家 | 2 |
| p007 | 107 | D7生产厂家 | 2 |
| p008 | 108 | D8生产厂家 | 3 |
| p009 | 109 | D9生产厂家 | 4 |
| p011 | 111 | D11生产厂家 | 2 |
+------+------+-------------+--------+
10 rows in set (0.13 sec)
mysql> select s_id,f_name,f_price from study_1 order by s_id desc;
+------+------------+---------+
| s_id | f_name | f_price |
+------+------------+---------+
| 110 | 开心葡萄酒 | 67.00 |
| 109 | 合力葡萄酒 | 66.00 |
| 109 | 飞悦葡萄酒 | 66.00 |
| 108 | 鸡尾酒 | 32.00 |
| 107 | 百世可乐 | 4.00 |
| 106 | 可口可乐 | 4.00 |
| 105 | 果粒橙 | 3.00 |
| 105 | 乐橙 | 3.00 |
| 105 | 开心果粒橙 | 3.00 |
| 104 | 香瓜 | 6.40 |
| 103 | 香蕉 | 2.20 |
| 103 | 橙子 | 9.20 |
| 102 | 橘子 | 3.20 |
| 102 | 火龙果 | 6.30 |
| 102 | 葡萄 | 5.30 |
| 101 | 苹果 | 9.20 |
| 101 | 黑莓 | 10.20 |
| 101 | 西瓜 | 7.20 |
+------+------------+---------+
18 rows in set (0.13 sec)
mysql> select s_id,f_name,f_price from study_1 order by s_id desc ,f_price desc ;
+------+------------+---------+
| s_id | f_name | f_price |
+------+------------+---------+
| 110 | 开心葡萄酒 | 67.00 |
| 109 | 合力葡萄酒 | 66.00 |
| 109 | 飞悦葡萄酒 | 66.00 |
| 108 | 鸡尾酒 | 32.00 |
| 107 | 百世可乐 | 4.00 |
| 106 | 可口可乐 | 4.00 |
| 105 | 果粒橙 | 3.00 |
| 105 | 乐橙 | 3.00 |
| 105 | 开心果粒橙 | 3.00 |
| 104 | 香瓜 | 6.40 |
| 103 | 橙子 | 9.20 |
| 103 | 香蕉 | 2.20 |
| 102 | 火龙果 | 6.30 |
| 102 | 葡萄 | 5.30 |
| 102 | 橘子 | 3.20 |
| 101 | 黑莓 | 10.20 |
| 101 | 苹果 | 9.20 |
| 101 | 西瓜 | 7.20 |
+------+------------+---------+
18 rows in set (0.07 sec)
mysql> select s_id,f_name,f_price from study_1 order by f_price desc,s_id desc ;
+------+------------+---------+
| s_id | f_name | f_price |
+------+------------+---------+
| 110 | 开心葡萄酒 | 67.00 |
| 109 | 合力葡萄酒 | 66.00 |
| 109 | 飞悦葡萄酒 | 66.00 |
| 108 | 鸡尾酒 | 32.00 |
| 101 | 黑莓 | 10.20 |
| 103 | 橙子 | 9.20 |
| 101 | 苹果 | 9.20 |
| 101 | 西瓜 | 7.20 |
| 104 | 香瓜 | 6.40 |
| 102 | 火龙果 | 6.30 |
| 102 | 葡萄 | 5.30 |
| 107 | 百世可乐 | 4.00 |
| 106 | 可口可乐 | 4.00 |
| 102 | 橘子 | 3.20 |
| 105 | 果粒橙 | 3.00 |
| 105 | 乐橙 | 3.00 |
| 105 | 开心果粒橙 | 3.00 |
| 103 | 香蕉 | 2.20 |
+------+------------+---------+
18 rows in set (0.09 sec)
mysql> select f_name,f_price from study_1 where f_price between 6 and 9;
+--------+---------+
| f_name | f_price |
+--------+---------+
| 火龙果 | 6.30 |
| 西瓜 | 7.20 |
| 香瓜 | 6.40 |
+--------+---------+
3 rows in set (0.07 sec)
mysql> select s_id ,count(*) as 根据s_id分组的总数 from study_1 group by s_id;
+------+--------------------+
| s_id | 根据s_id分组的总数 |
+------+--------------------+
| 101 | 3 |
| 102 | 3 |
| 103 | 2 |
| 104 | 1 |
| 105 | 3 |
| 106 | 1 |
| 107 | 1 |
| 108 | 1 |
| 109 | 2 |
| 110 | 1 |
+------+--------------------+
10 rows in set (0.07 sec)
mysql> select s_id ,sum(f_price) as 根据s_id分组sum函数f_price函数体 from study_1 group by s_id;
+------+----------------------------------+
| s_id | 根据s_id分组sum函数f_price函数体 |
+------+----------------------------------+
| 101 | 26.60 |
| 102 | 14.80 |
| 103 | 11.40 |
| 104 | 6.40 |
| 105 | 9.00 |
| 106 | 4.00 |
| 107 | 4.00 |
| 108 | 32.00 |
| 109 | 132.00 |
| 110 | 67.00 |
+------+----------------------------------+
10 rows in set (0.06 sec)
mysql> select s_id ,avg(f_price) as 根据s_id分组求分组的f_price平均值 from study_1 group by s_id;
+------+-----------------------------------+
| s_id | 根据s_id分组求分组的f_price平均值 |
+------+-----------------------------------+
| 101 | 8.866667 |
| 102 | 4.933333 |
| 103 | 5.700000 |
| 104 | 6.400000 |
| 105 | 3.000000 |
| 106 | 4.000000 |
| 107 | 4.000000 |
| 108 | 32.000000 |
| 109 | 66.000000 |
| 110 | 67.000000 |
+------+-----------------------------------+
10 rows in set (0.06 sec)
mysql> select max(f_price) as f_price最大值 from study_1;
+---------------+
| f_price最大值 |
+---------------+
| 67.00 |
+---------------+
1 row in set (0.04 sec)
mysql> select min(f_price) as f_price最大值 from study_1;
+---------------+
| f_price最大值 |
+---------------+
| 2.20 |
+---------------+
1 row in set (0.05 sec)
mysql> select f_type,count(*) as 根据f_type分组的总数 from study_1 group by f_type having count(*)>3;
+--------+----------------------+
| f_type | 根据f_type分组的总数 |
+--------+----------------------+
| fruit | 9 |
| drink | 5 |
| wine | 4 |
+--------+----------------------+
3 rows in set (0.05 sec)
mysql> select s_id,f_name from study_1
where s_id in (102,106,108);
+------+----------+
| s_id | f_name |
+------+----------+
| 102 | 橘子 |
| 102 | 火龙果 |
| 102 | 葡萄 |
| 106 | 可口可乐 |
| 108 | 鸡尾酒 |
+------+----------+
5 rows in set (0.04 sec)
mysql> select s_id ,count(*) as 求s_id满足条件的总数包括空值 from study_1 where s_id in (102,106,108)
group by s_id;
+------+------------------------------+
| s_id | 求s_id满足条件的总数包括空值 |
+------+------------------------------+
| 102 | 3 |
| 106 | 1 |
| 108 | 1 |
+------+------------------------------+
3 rows in set (0.05 sec)
mysql> select s_id ,count(s_id) as 求s_id满足条件且值不为空总数 from study_1 where s_id in (102,106,108)
group by s_id;
+------+------------------------------+
| s_id | 求s_id满足条件且值不为空总数 |
+------+------------------------------+
| 102 | 3 |
| 106 | 1 |
| 108 | 1 |
+------+------------------------------+
3 rows in set (0.04 sec)
mysql> select s_id ,sum(s_id) as 求s_id满足条件的和 from study_1 where s_id in (102,106,108)
group by s_id;
+------+--------------------+
| s_id | 求s_id满足条件的和 |
+------+--------------------+
| 102 | 306 |
| 106 | 106 |
| 108 | 108 |
+------+--------------------+
3 rows in set (0.04 sec)
mysql> select s_id as 生产厂家ID,f_name as 产品名称,f_price 产品价格 from study_1 as 产品列表
left join study_2 as
生产厂家 on 产品列表.s_id= 生产厂家.f_id;
+------------+------------+----------+
| 生产厂家ID | 产品名称 | 产品价格 |
+------------+------------+----------+
| 101 | 苹果 | 9.20 |
| 101 | 黑莓 | 10.20 |
| 101 | 西瓜 | 7.20 |
| 102 | 橘子 | 3.20 |
| 102 | 火龙果 | 6.30 |
| 102 | 葡萄 | 5.30 |
| 103 | 香蕉 | 2.20 |
| 103 | 橙子 | 9.20 |
| 104 | 香瓜 | 6.40 |
| 105 | 果粒橙 | 3.00 |
| 105 | 乐橙 | 3.00 |
| 105 | 开心果粒橙 | 3.00 |
| 106 | 可口可乐 | 4.00 |
| 107 | 百世可乐 | 4.00 |
| 108 | 鸡尾酒 | 32.00 |
| 109 | 合力葡萄酒 | 66.00 |
| 109 | 飞悦葡萄酒 | 66.00 |
| 110 | 开心葡萄酒 | 67.00 |
+------------+------------+----------+
18 rows in set (0.08 sec)
mysql> select s_id as 生产厂家ID,f_name as 产品名称,f_price 产品价格 from study_1 as 产品列表
right join study_2 as
生产厂家 on 产品列表.s_id= 生产厂家.f_id;
+------------+------------+----------+
| 生产厂家ID | 产品名称 | 产品价格 |
+------------+------------+----------+
| 101 | 苹果 | 9.20 |
| 101 | 黑莓 | 10.20 |
| 102 | 橘子 | 3.20 |
| 103 | 香蕉 | 2.20 |
| 102 | 火龙果 | 6.30 |
| 102 | 葡萄 | 5.30 |
| 103 | 橙子 | 9.20 |
| 101 | 西瓜 | 7.20 |
| 104 | 香瓜 | 6.40 |
| 105 | 果粒橙 | 3.00 |
| 105 | 乐橙 | 3.00 |
| 105 | 开心果粒橙 | 3.00 |
| 106 | 可口可乐 | 4.00 |
| 107 | 百世可乐 | 4.00 |
| 108 | 鸡尾酒 | 32.00 |
| 109 | 合力葡萄酒 | 66.00 |
| 109 | 飞悦葡萄酒 | 66.00 |
| NULL | NULL | NULL |
+------------+------------+----------+
18 rows in set (0.09 sec)
mysql> select s_id as 生产厂家ID,f_name as 产品名称,f_price 产品价格 from study_1 as 产品列表
join study_2 as
生产厂家 on 产品列表.s_id= 生产厂家.f_id;
+------------+------------+----------+
| 生产厂家ID | 产品名称 | 产品价格 |
+------------+------------+----------+
| 101 | 苹果 | 9.20 |
| 101 | 黑莓 | 10.20 |
| 102 | 橘子 | 3.20 |
| 103 | 香蕉 | 2.20 |
| 102 | 火龙果 | 6.30 |
| 102 | 葡萄 | 5.30 |
| 103 | 橙子 | 9.20 |
| 101 | 西瓜 | 7.20 |
| 104 | 香瓜 | 6.40 |
| 105 | 果粒橙 | 3.00 |
| 105 | 乐橙 | 3.00 |
| 105 | 开心果粒橙 | 3.00 |
| 106 | 可口可乐 | 4.00 |
| 107 | 百世可乐 | 4.00 |
| 108 | 鸡尾酒 | 32.00 |
| 109 | 合力葡萄酒 | 66.00 |
| 109 | 飞悦葡萄酒 | 66.00 |
+------------+------------+----------+
17 rows in set (0.08 sec)
mysql> select s_id as 生产厂家ID,f_name as 产品名称,f_price 产品价格
from study_1 as 产品列表
left join study_2 as
生产厂家 on 产品列表.s_id= 生产厂家.f_id
where 生产厂家.p_star>3;
+------------+------------+----------+
| 生产厂家ID | 产品名称 | 产品价格 |
+------------+------------+----------+
| 102 | 橘子 | 3.20 |
| 102 | 火龙果 | 6.30 |
| 102 | 葡萄 | 5.30 |
| 104 | 香瓜 | 6.40 |
| 105 | 果粒橙 | 3.00 |
| 105 | 乐橙 | 3.00 |
| 105 | 开心果粒橙 | 3.00 |
| 109 | 合力葡萄酒 | 66.00 |
| 109 | 飞悦葡萄酒 | 66.00 |
+------------+------------+----------+
9 rows in set (0.10 sec)
mysql> select f_type as 产品类型, count(*) as 根据f_type分组的总数
from study_1 as 产品列表
left join study_2 as
生产厂家 on 产品列表.s_id= 生产厂家.f_id where 生产厂家.p_star>3
group by f_type;
+----------+----------------------+
| 产品类型 | 根据f_type分组的总数 |
+----------+----------------------+
| fruit | 4 |
| drink | 3 |
| wine | 2 |
+----------+----------------------+
3 rows in set (0.07 sec)
mysql> select f_type as 产品类型, count(*) as 根据f_type分组的总数
from study_1 as 产品列表
left join study_2 as
生产厂家 on 产品列表.s_id= 生产厂家.f_id where 生产厂家.p_star>3
group by f_type having count(*)>3;
+----------+----------------------+
| 产品类型 | 根据f_type分组的总数 |
+----------+----------------------+
| fruit | 4 |
+----------+----------------------+
1 row in set (0.07 sec)
mysql> select f_name as 产品名称
from study_1
where s_id in
(select f_id from study_2 where p_id='p002');
+----------+
| 产品名称 |
+----------+
| 橘子 |
| 火龙果 |
| 葡萄 |
+----------+
3 rows in set (0.06 sec)
mysql> select f_id 产品id,s_id as 生产厂家p002对应的f_id ,f_name as 产品名称
from study_1 where s_id in
(select f_id from study_2 where p_id='p002');
+--------+------------------------+----------+
| 产品id | 生产厂家p002对应的f_id | 产品名称 |
+--------+------------------------+----------+
| 003 | 102 | 橘子 |
| 005 | 102 | 火龙果 |
| 006 | 102 | 葡萄 |
+--------+------------------------+----------+
3 rows in set (0.06 sec)
mysql> select s_id as 生产厂家p002对应的f_id ,sum(s_id) as 求s_id的sum和
from study_1 where s_id in
(select f_id from study_2 where p_id='p002');
+------------------------+---------------+
| 生产厂家p002对应的f_id | 求s_id的sum和 |
+------------------------+---------------+
| 102 | 306 |
+------------------------+---------------+
1 row in set (0.06 sec)
mysql> select s_id as 生产厂家p002对应的f_id ,count(s_id) as 求s_id的列数不包括null
from study_1 where s_id in
(select f_id from study_2 where p_id='p002');
+------------------------+------------------------+
| 生产厂家p002对应的f_id | 求s_id的列数不包括null |
+------------------------+------------------------+
| 102 | 3 |
+------------------------+------------------------+
1 row in set (0.07 sec)