1. 背景
* CURD 操作通常是使用关系型数据库系统中的结构化查询语言(Structured Query Language,SQL)完成的
* CURD 定义了用于处理数据的基本原子操作
* CURD 代表创建(Create)、更新(Update)、读取(Retrieve)和删除(Delete)操作。
2. 创建表操作
* 创建数据库(DB) mytest
CHARACTER SET: 设置字符集mysql> CREATE DATABASE mytest CHARACTER SET utf8mb4;
Query OK, 1 row affected (0.00 sec)
* 在数据库中创建表(table)
ENGINE=INNODB 指定Innodb 存储引擎
CHARSET=utf8mb4 设置表字符集mysql> CREATE TABLE users(
-> id BIGINT PRIMARY KEY NOT NULL AUTO_INCREMENT,
-> name VARCHAR(32) NOT NULL,
-> sex ENUM('M', 'F') NOT NULL,
-> age INT NOT NULL
-> )ENGINE=INNODB CHARSET=utf8mb4;
Query OK, 0 rows affected (0.03 sec)
3. 插入数据操作
* select 插入单条数据mysql> INSERT INTO users SELECT NULL, 'tom', 'M', 29;
Query OK, 1 row affected (0.01 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> select * from users;
+----+------+-----+-----+
| id | name | sex | age |
+----+------+-----+-----+
| 1 | tom | M | 29 |
+----+------+-----+-----+
1 row in set (0.00 sec)
* values 插入单条数据mysql> INSERT INTO users VALUES (NULL, 'jak', 'F', 33);
Query OK, 1 row affected (0.01 sec)
mysql> select * from users;
+----+------+-----+-----+
| id | name | sex | age |
+----+------+-----+-----+
| 1 | tom | M | 29 |
| 2 | jak | F | 33 |