mysql增删改查进阶语句
时间: 2023-07-06 08:30:24 浏览: 67
好的,以下是 MySQL 的增删改查进阶语句:
1. 插入数据
- 插入单行数据:
```
INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);
```
- 插入多行数据:
```
INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...), (value1, value2, value3, ...), ...;
```
2. 更新数据
- 更新单张表中满足条件的数据:
```
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
```
- 更新多张表中满足条件的数据:
```
UPDATE table1, table2 SET table1.column1 = value1, table2.column2 = value2 WHERE table1.column = table2.column AND condition;
```
3. 删除数据
- 删除单张表中满足条件的数据:
```
DELETE FROM table_name WHERE condition;
```
- 删除多张表中满足条件的数据:
```
DELETE table1, table2 FROM table1, table2 WHERE table1.column = table2.column AND condition;
```
4. 查询数据
- 查询单张表中所有数据:
```
SELECT * FROM table_name;
```
- 查询单张表中满足条件的数据:
```
SELECT * FROM table_name WHERE condition;
```
- 查询多张表中满足条件的数据:
```
SELECT * FROM table1, table2 WHERE table1.column = table2.column AND condition;
```
以上是 MySQL 的增删改查进阶语句,希望能对你有所帮助。
相关推荐
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)