mysql的增删改查、CRUD操作

CRUD（专业术语）：增删改查

C：create

R：read或resultSet

U：update

D：delete

操作素材

1. 添加一条数据

语法：insert into 表名 (列1,列2,列3······)values(值1,值2,值3······);

示例：

mysql> insert into t_student (t_studentnumber,t_name,t_birthday,t_height) values ('S001','lilei',now(),16);
Query OK, 1 row affected, 1 warning (0.02 sec)

mysql> insert into t_student (t_studentnumber,t_name,t_birthday,t_height) values ('S002','hanmeimei','2000-01-01',160);
Query OK, 1 row affected (0.02 sec)

2. 查询数据

语法：select 列1,列2······ from 表名;

示例：

mysql> select t_studentnumber,t_name,t_birthday,t_height from t_student;
+-----------------+-----------+------------+----------+
| t_studentnumber | t_name    | t_birthday | t_height |
+-----------------+-----------+------------+----------+
| S001            | lilei     | 2022-03-15 |       16 |
| S002            | hanmeimei | 2000-01-01 |      160 |
+-----------------+-----------+------------+----------+
2 rows in set (0.00 sec)

3. 修改数据

把lilei的出生日期修改成2002-03-02

语法：update 表名 set 字段1=值1,字段2=值2··· where 字段=值

mysql> update t_student set t_birthday = '2003-03-02' where t_studentnumber = 'S001';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

4. 删除数据

删除hanmeimei

语法：

delete from 表;删除所有的数据

delete from 表 where 条件

示例：

mysql> delete from t_student where t_name = 'hanmeimei';
Query OK, 1 row affected (0.00 sec)

5. 检查表格

mysql> select * from t_student;
+-----------------+--------+------------+----------+
| t_studentnumber | t_name | t_birthday | t_height |
+-----------------+--------+------------+----------+
| S001            | lilei  | 2003-03-02 |       16 |
+-----------------+--------+------------+----------+
1 row in set (0.00 sec)