MySQL数据操作：增、删、查、改全面解析

mysql -uroot -p***

show databases;
输出结果：
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.24 sec)

use mysql

exit;

mysql> create database Text;
Query OK, 1 row affected (0.08 sec)

mysql> show tables;
Empty set (0.00 sec) # 空集合，就是没有表

mysql> create table BOOK (
-> name varchar(20),
-> owner varchar(20),
-> death date);
Query OK, 0 rows affected (0.26 sec)
# 查看数据表是否创建成功
mysql> show tables;
+----------------+
| Tables_in_text |
+----------------+
| book |
+----------------+
1 row in set (0.00 sec) //大写的数据库名和表名全部变为小写

mysql> describe book;==mysql> desc book;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| name | varchar(20) | YES | | NULL | |
| owner | varchar(20) | YES | | NULL | |
| death | date | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
3 rows in set (0.03 sec)
# 查看表中的记录
mysql> select * from book;
Empty set (0.02 sec)

mysql> insert into book
-> values('English','qiulizhen','2021-09-15');
Query OK, 1 row affected (0.08 sec)
# 查看表中的记录
mysql> select * from book;
+---------+-----------+------------+
| name | owner | death |
+---------+-----------+------------+
| English | qiulizhen | 2021-09-15 |
+---------+-----------+------------+
1 row in set (0.00 sec)

mysql> delete from book where name='maths';
Query OK, 1 rows affected (0.09 sec)

mysql> update book set name='英语' where death='2021-09-15';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
# 再次查看表中数据
mysql> select * from book;
+------+-----------+------------+
| name | owner | death |
+------+-----------+------------+
| 英语 | qiulizhen | 2021-09-15 |
| 语文 | 小邱 | 2020-09-21 |
+------+-----------+------------+
2 rows in set (0.00 sec)