MySql基础练习题100道（1-50）

阳光穿透心脏的1/2处 2023-07-25 09:09 48阅读 0赞

## 一、基础： ##

### 1、在命令行中启动MySql： ###

解：net start mysql

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70][]

### 2、在命令行中关闭MySql： ###

解：net stop mysql

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 1][]

### 3、使用运行连接MySql数据库： ###

解：mysql -uroot -p

![20200414123732342.png][]

再在命令行中输入：mysql密码

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 2][]

### 4、使用命令在命令行中查看所有的数据库： ###

解：show databases;(注：命令后必须跟上英文分号)

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 3][]

### 5、使用命令在命令行中进入某个数据库： ###

解：use 需要进入的数据库；(注：命令后必须跟上英文分号)

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 4][]

### 6、使用命令在命令行中查看指定数据库中的所有表： ###

解：show tables；(注：命令后必须跟上英文分号)

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 5][]

### 7、使用命令在命令行中创建一个名为demo1的数据库： ###

解：create database demo1；(注：命令后必须跟上英文分号)

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 6][]

### 8、使用命令删除名为demo1的数据库： ###

解：drop database demo1;(注：命令后必须跟上英文分号)

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 7][]

### 9、使用命令创建一个学生信息表（t\_student）列为（id、name、age、email），id为主键且自增： ###

解：CREATE TABLE t\_student(

id BIGINT PRIMARY KEY AUTO\_INCREMENT,

name VARCHAR(30),

age INT,

email VARCHAR(30)

)（注：每列需要英文逗号隔开，最后一列不需要）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 8][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 9][]

### 10、使用命令删除t\_student表： ###

解：DROP TABLE t\_student

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 10][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 11][]

### 11、使用命令创建一个名为order表，列：id(主键且自增)、name、age： ###

解：CREATE TABLE \`order\`(

id BIGINT PRIMARY KEY AUTO\_INCREMENT,

name VARCHAR(30),

age INT

)（注：每列需要英文逗号隔开，最后一列不需要。表名不能使用关键字，如果要使用需要反引号括起来）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 12][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 13][]

### 12、使用命令删除order表： ###

解：DROP TABLE \`order\`（注：表名不能使用关键字，如果要使用需要反引号括起来）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 14][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 15][]

## 二、增加： ##

### 建表语句： ###

CREATE TABLE t\_student(  
id BIGINT PRIMARY KEY AUTO\_INCREMENT,  
name VARCHAR(30),  
age INT,  
email VARCHAR(30)  
)

### 1、使用语句插入一条学生信息到t\_student表（张三、18、10000@qq.com）: ###

解：INSERT INTO t\_student(name,age,email)VALUES('张三',18,'10000@qq.com')

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 16][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 17][]

### 2、使用语句插入部分学生信息到t\_student表（周七、22）: ###

解：INSERT INTO t\_student(name,age)VALUE('周七',22)

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 18][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 19][]

### 3、使用语句插入多条学生信息到t\_student表（赵六、18、40000@qq.com）（李四、19、20000@qq.com）(王五、20、30000@qq.com)： ###

解：INSERT INTO t\_student(name,age,email)

VALUES ('李四',19,'20000@qq.com'),('赵六',18,'40000@qq.com'),('王五',20,'30000@qq.com')

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 20][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 21][]

### 4、插入查询出来的学生姓名： ###

解：INSERT INTO t\_student (name) SELECT name FROM t\_student

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 22][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 23][]

## 三、删除和更改： ##

### 1、删除id为6的学生： ###

解：DELETE FROM t\_student WHERE id=6

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 24][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 25][]

### 2、修改id为7的学生的姓名为赵匡胤： ###

解：UPDATE t\_student SET name='赵匡胤' WHERE id=7

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 26][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 27][]

### 3、修改id为3的学生，名字为张三丰，年龄140，邮箱为zhangsanf@： ###

解：UPDATE t\_student SET name='张三丰',age=140,email='zhangsanf@'

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 28][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 29][]

### 4、删除所有的学生信息： ###

解：DELETE FROM t\_student

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 30][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 31][]

## 四、查询： ##

### 建表语句： ###

CREATE TABLE \`product\` (  
\`id\` bigint(20) NOT NULL AUTO\_INCREMENT,  
\`productName\` varchar(50) DEFAULT NULL,  
\`dir\_id\` bigint(20) DEFAULT NULL,  
\`salePrice\` double(10,2) DEFAULT NULL,  
\`supplier\` varchar(50) DEFAULT NULL,  
\`brand\` varchar(50) DEFAULT NULL,  
\`cutoff\` double(2,2) DEFAULT NULL,  
\`costPrice\` double(10,2) DEFAULT NULL,  
PRIMARY KEY (\`id\`)  
) ENGINE=InnoDB AUTO\_INCREMENT=22 DEFAULT CHARSET=utf8;

### 插入信息： ###

INSERT INTO \`product\` VALUES ('1', '罗技M90', '3', '90.00', '罗技', '罗技', '0.50', '35.00');  
INSERT INTO \`product\` VALUES ('2', '罗技M100', '3', '49.00', '罗技', '罗技', '0.90', '33.00');  
INSERT INTO \`product\` VALUES ('3', '罗技M115', '3', '99.00', '罗技', '罗技', '0.60', '38.00');  
INSERT INTO \`product\` VALUES ('4', '罗技M125', '3', '80.00', '罗技', '罗技', '0.90', '39.00');  
INSERT INTO \`product\` VALUES ('5', '罗技木星轨迹球', '3', '182.00', '罗技', '罗技', '0.80', '80.00');  
INSERT INTO \`product\` VALUES ('6', '罗技火星轨迹球', '3', '349.00', '罗技', '罗技', '0.87', '290.00');  
INSERT INTO \`product\` VALUES ('7', '罗技G9X', '3', '680.00', '罗技', '罗技', '0.70', '470.00');  
INSERT INTO \`product\` VALUES ('8', '罗技M215', '2', '89.00', '罗技', '罗技', '0.79', '30.00');  
INSERT INTO \`product\` VALUES ('9', '罗技M305', '2', '119.00', '罗技', '罗技', '0.82', '48.00');  
INSERT INTO \`product\` VALUES ('10', '罗技M310', '2', '135.00', '罗技', '罗技', '0.92', '69.80');  
INSERT INTO \`product\` VALUES ('11', '罗技M505', '2', '148.00', '罗技', '罗技', '0.92', '72.00');  
INSERT INTO \`product\` VALUES ('12', '罗技M555', '2', '275.00', '罗技', '罗技', '0.88', '140.00');  
INSERT INTO \`product\` VALUES ('13', '罗技M905', '2', '458.00', '罗技', '罗技', '0.88', '270.00');  
INSERT INTO \`product\` VALUES ('14', '罗技MX1100', '2', '550.00', '罗技', '罗技', '0.76', '300.00');  
INSERT INTO \`product\` VALUES ('15', '罗技M950', '2', '678.00', '罗技', '罗技', '0.78', '320.00');  
INSERT INTO \`product\` VALUES ('16', '罗技MX Air', '2', '1299.00', '罗技', '罗技', '0.72', '400.00');  
INSERT INTO \`product\` VALUES ('17', '罗技G1', '4', '155.00', '罗技', '罗技', '0.80', '49.00');  
INSERT INTO \`product\` VALUES ('18', '罗技G3', '4', '229.00', '罗技', '罗技', '0.77', '96.00');  
INSERT INTO \`product\` VALUES ('19', '罗技G500', '4', '399.00', '罗技', '罗技', '0.88', '130.00');  
INSERT INTO \`product\` VALUES ('20', '罗技G700', '4', '699.00', '罗技', '罗技', '0.79', '278.00');  
INSERT INTO \`product\` VALUES ('21', '光盘', null, '10.00', '罗技', '罗技', '0.80', '2.00');

### 1、查询所有货品信息： ###

解:SELECT \* FROM product

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 32][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 33][]

### 2、查询所有货品的id、productName、salePrice： ###

解：SELECT id,productName,salePrice FROM product

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 34][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 35][]

### 3、查询商品的分类编号： ###

解：SELECT dir\_id FROM product

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 36][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 37][]

### 4、查询所有商品的id、名称、批发价（salePrice\*cutoff）： ###

解：SELECT id,productName,salePrice\*cutoff FROM product

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 38][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 39][]

### 5、查询所有货品的id、名称、和各进50个的的成本价（costPrice）： ###

解：SELECT id,productName,costPrice\*50 FROM product

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 40][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 41][]

### 6、查询所有货品的id、名称、各进50个，并且每个运费1元的成本： ###

解：SELECT id,productName,(costPrice+1)\*50 FROM product

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 42][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 43][]

### 7、查询所有货品的id、名称、各进50个，并且每个运费1元的成本（别名allPrice）： ###

解：SELECT id,productName,(costPrice+1)\*50 AS allPrice FROM product

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 44][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 45][]

### 8、查询商品的分类编号（去除重复）： ###

解：SELECT DISTINCTdir\_id FROM product

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 46][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 47][]

### 9、查询货品零售价salePrice）119的所有商品信息： ###

解：SELECT \* FROM product WHERE salePrice=119

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 48][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 49][]

### 10、查询货品名为罗技G9X的所有货品信息： ###

解：SELECT \* FROM product productName='罗技G9X'

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 50][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 51][]

### 11、查询货品名不为罗技G9X的所有商品信息： ###

解：SELECT \* FROM product WHERE productName!='罗技G9X'

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 52][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 53][]

### 12、查询分类编号不等于2的所有货品信息： ###

解：SELECT \* FROM product WHERE dir\_id!=2

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 54][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 55][]

### 13、查询货品名称、零售价（salePrice）小于等于200的货品： ###

解：SELECT productName,salePrice FROM product WHERE salePrice<=200

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 56][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 57][]

### 14、查询id、货品名称、批发价(salePrice\*cutoff)大于350的货品： ###

解：SELECT id,productName,salePrice\*cutoff FROM product WHERE salePrice\*cutoff>=350

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 58][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 59][]

### 15、查询id、商品名称 零售价（salePrice）在300-400之间的货品： ###

解：SELECT id,productName,salePrice FROM product WHERE salePrice>=300 AND salePrice<=400

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 60][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 61][]

### 16、查询id、商品名称 分类为2和4的所有商品： ###

解：SELECT id,productName dir\_id FROM product WHERE dir\_id=2 OR dir\_id=4

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 62][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 63][]

### 17、查询id、商品名称、分类编号、salePrice、costPrice的货品零售价大于等于250或者成本大于等于200的商品： ###

解：SELECT id,productName,dir\_id,salePrice,costPrice FROM product WHERE salePrice>=250 OR costPrice>=200

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 64][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 65][]

### 18、查询id、货品名称，批发价在300-400之间的货品,使用区间查询： ###

解：SELECT id,productName,salePrice FROM product WHERE salePrice BETWEEN 300 AND 400

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 66][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 67][]

### 19、查询id、货品名称，批发价不在300-400之间的货品；使用区间查询： ###

解：SELECT id,productName,salePrice FROM product WHERE salePrice NOT BETWEEN 300 AND 400

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 68][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 69][]

### 20、查询id、货品名称，分类编号为2,4的所有商品，使用IN： ###

解：SELECT id,productName,dir\_id FROM product WHERE dir\_id IN(2,4)

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 71][]

### 21、查询id、货品名称，分类编号不为2,4的所有商品，使用IN： ###

解：SELECT id,productName,dir\_id FROM product WHERE dir\_id NOT IN(2,4)

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 72][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 73][]

### 22、查询分类编号为空的所有商品信息： ###

解：SELECT id,productName,dir\_id FROM product WHERE dir\_id IS NULL

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 74][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 75][]

### 23、查询id、货品名称，货品名称匹配'罗技M9\_'的商品信息： ###

解：SELECT id,productName FROM product WHERE productName LIKE '罗技M9\_'

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 76][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 77][]

### 24、查询id、货品名称、分类编号，零售价大于等于80并且货品名称匹配'%罗技M1\_ \_'： ###

解：SELECT id,productName,dir\_id,salePrice FROM product WHERE salePrice>=80 AND productName LIKE '%罗技M1\_\_'

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 78][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 79][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70]: /images/20230528/eaae33e1083643e398837e05823597f8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 1]: /images/20230528/78708bb3e8dc4ba3a732db149ea490e5.png
[20200414123732342.png]: /images/20230528/d7b5997c880646ed9ba91af901681432.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 2]: /images/20230528/c44b4592088a41939f1fa37d2bb07380.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 3]: /images/20230528/cd49d27a22d4457eaeacd29eec7ab68c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 4]: /images/20230528/983a66884d6e42fd9b509196e6bba8ec.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 5]: /images/20230528/b63a4ae3b3cd480ea30dcccef1f56779.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 6]: /images/20230528/89b7042e5e7d4e3bb68ece4f99b77cb7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 7]: /images/20230528/d6e6fe3fc8674e83b7e4f2ff01eef936.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 8]: /images/20230528/62bb48246d794d22b7a13839c106a27e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 9]: /images/20230528/22c8afe36ed9407db2ffb7995e2a1a76.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 10]: /images/20230528/b2f2cd62fc1e4fbabae099537bfd9749.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 11]: /images/20230528/6f1968c112e34ab0a4d48e149f1f6934.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 12]: /images/20230528/acc46462bfff4220998bca51e0b96633.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 13]: /images/20230528/5f0c6b11a9754a19ac60404ba3324419.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 14]: /images/20230528/49aebc30b9d54a99a6a5de00847c7ef4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 15]: /images/20230528/9adc3f9074f44cbe9e0fb2bca4a0eb2a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 16]: /images/20230528/5d422aa060ec4697ac45fc96907d2434.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 17]: /images/20230528/325d00c9405642b991e9e78c94a54d21.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 18]: /images/20230528/a14be2861c6d49f7b26067c20d4996c2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 19]: /images/20230528/b113476ea3f944e3a6621f9734b10ffc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 20]: /images/20230528/fde49a0a1dd74712ba7837e43aed56e1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 21]: /images/20230528/2e731309ed274810b55e82f1bd51382d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 22]: /images/20230528/30b2ae841dda471dabeda6bf9c03f4de.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 23]: /images/20230528/81f05f91bde242828c5fdc3dde25a864.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 24]: /images/20230528/2d26a8127d194d7c9354c127d36b04d3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 25]: /images/20230528/f055892d9b9e4b7db5aa464226b63cb8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 26]: /images/20230528/f559724950fa471a8e9e13dba9e1094b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 27]: /images/20230528/fe12b7324f894d23adc7e158e73a66d3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 28]: /images/20230528/93b7b65b84ad409aa383d408bd58bbb0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 29]: /images/20230528/5b577180539347b187979c067160332d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 30]: /images/20230528/6def8bf5d20348839079b90d3dd6a095.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 31]: /images/20230528/b141143c0fbc42248115a1f4db4836f3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 32]: /images/20230528/ad92ecb121be4edc9906e316456d6b28.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 33]: /images/20230528/a45472146cf74322982813d293884851.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 34]: /images/20230528/d65e5345ebcd4cf6a795f1822f0bdf2d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 35]: /images/20230528/fb960ccd69b64acbb529fe203877671e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 36]: /images/20230528/c53c46146f2b4edeade85d193b2ddbd1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 37]: /images/20230528/31f03243a34b46d3ab41dd3192141fdc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 38]: /images/20230528/7c82a561723d48f391bdc9981469d5f8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 39]: /images/20230528/1419dc760b6442cdb59b913e6e0a31f1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 40]: /images/20230528/586cea834747466cb98ce4dd32cd7dbf.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 41]: /images/20230528/d35355a1ee8b4a478282540cdb034d49.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 42]: /images/20230528/d71e8e753d3740ee88276c0ca46d9dbb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 43]: /images/20230528/4777a785f61644f79c4fc90859615739.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 44]: /images/20230528/7bd90a7b8b4543a6a5e3e794d07ae4e6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 45]: /images/20230528/0a1d6f667c384d529d9c905ab28eff24.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 46]: /images/20230528/777ba84e8e6a4ed4b56fb6b02be88e0e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 47]: /images/20230528/4e364e1d659f40b9819f24015148e16b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 48]: /images/20230528/b247a6d966a94f6dade1d1fd08be0419.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 49]: /images/20230528/ab63489173d54d89ae7482f6e0de906e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 50]: /images/20230528/8675e23640674d338d99d23cafae9470.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 51]: /images/20230528/136a2c6b270d4075b53ad893649cc012.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 52]: /images/20230528/7f822c6d060b474cb696dd1908a191f4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 53]: /images/20230528/7a40a11b5cb84b7fb4882f61341ba5b1.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 54]: /images/20230528/76fb598470124e41a18d0e8f1e3fe50b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 55]: /images/20230528/843335732a0c4dc3903599ebda1c18a7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 56]: /images/20230528/9cff791041394bde996421a73b8241b9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 57]: /images/20230528/3aa0855dbbbb4da2be8868cc1f32975d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 58]: /images/20230528/8aa7cf2a4004414298d086a2f417860c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 59]: /images/20230528/8d70519c02ac43c7bc9cb45efeb797c7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 60]: /images/20230528/f692cb3d6d8047af8062a0b93f58a31c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 61]: /images/20230528/a6b238317fb04a4dac40bd172443bc73.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 62]: /images/20230528/dd18077bf9704d9d815aa6cde50e0641.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 63]: /images/20230528/98badb20e64e40b8a02b7374f058c490.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 64]: /images/20230528/b7f95fdf572e4c71b7fd4e57e1ce9988.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 65]: /images/20230528/554ce05bb893406d98c0d43917cc55ab.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 66]: /images/20230528/8aa05b4cae89493da2d5f4dc4a462a87.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 67]: /images/20230528/a67de5f2381248b5b3a679b370fff08a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 68]: /images/20230528/d642ced7be59411e8702cd5a9cc64ba5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 69]: /images/20230528/bcbd38cfbaac432da5df744bff5dab9f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 70]: /images/20230528/0179e474c34e4cbfaca4fb003c337f90.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 71]: /images/20230528/3358473c888f4725984164b70c490a7c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 72]: /images/20230528/9231a6fbc5464aa28545eb4d4a57639b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 73]: /images/20230528/60c08763bd5e46ff938a99b746dce0bf.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 74]: /images/20230528/27ab71f7639c457798e88b495bb5a45d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 75]: /images/20230528/545c88ca92374c63a9c3faf16782996f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 76]: /images/20230528/7b69fb551c3245cd830c0f0883a504b5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 77]: /images/20230528/386f4bcfe6fe49a58ad076ca1062222a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 78]: /images/20230528/2d45d4010e41429091036c76ad586135.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NTY2NDg1NA_size_16_color_FFFFFF_t_70 79]: /images/20230528/ca9a445a92bd44d394a432a1a692f433.png