mysql增删改查语句汇总
时间: 2024-10-15 10:30:27 浏览: 10
MySQL是一种常用的的关系型数据库管理系统,其基本操作包括增加(INSERT)、删除(DELETE)、更新(UPDATE)和查询(SELECT)。以下是这四个操作的基本语法:
1. **插入数据(INSERT)**:
```sql
INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);
```
例如:向名为`users`的表添加一条新用户信息
```sql
INSERT INTO users (name, email) VALUES ('张三', 'zhangsan@example.com');
```
2. **删除记录(DELETE)**:
```sql
DELETE FROM table_name WHERE condition;
```
例如:删除`users`表中名字为"李四"的用户
```sql
DELETE FROM users WHERE name = '李四';
```
3. **更新数据(UPDATE)**:
```sql
UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition;
```
例如:将`users`表中名字为"王五"的用户的邮箱改为"wangwu@example.com"
```sql
UPDATE users SET email = 'wangwu@example.com' WHERE name = '王五';
```
4. **查询数据(SELECT)**:
```sql
SELECT column1, column2, ... FROM table_name WHERE condition;
```
例如:获取`users`表中的所有用户信息
```sql
SELECT * FROM users;
```
阅读全文