mysql stm32_MySQL子查询

首先创建表：

create table `t_pricelevel` (

`id` int ,

`priceLevel` int ,

`price` float ,

`description` varchar (300)

);

insert into `t_pricelevel` (`id`, `priceLevel`, `price`, `description`) values('1','1','80.00','价格贵的书');

insert into `t_pricelevel` (`id`, `priceLevel`, `price`, `description`) values('2','2','60.00','价格适中的书');

insert into `t_pricelevel` (`id`, `priceLevel`, `price`, `description`) values('3','3','40.00','价格便宜的书');

====================================================================================

t_book:

t_booktype:

t_pricelevel: