MySQL 数据库操作示例：创建、插入、查询、更新、删除

以下表格展示了使用 MySQL 进行数据库操作的步骤，包括创建表、插入数据、查询数据、更新数据和删除数据，并记录了每个操作的时间和执行结果。

| # | Time | Action | Message | Duration / Fetch | |---|---|---|---|---| | 0 | 23:56:04 | CREATE TABLE student ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50) NOT NULL, gender ENUM('男', '女') NOT NULL, age INT NOT NULL, class_id INT NOT NULL, FOREIGN KEY (class_id) REFERENCES class(id) ) | Error Code: 1824. Failed to open the referenced table 'class' | 0.000 sec 报错 | | 1 | 23:56:05 | CREATE TABLE class ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50) NOT NULL ) | | 0.000 sec 成功创建表class | | 2 | 23:56:06 | INSERT INTO class (name) VALUES ('一年级'), ('二年级'), ('三年级') | | 0.000 sec 成功插入三条记录 | | 3 | 23:56:07 | INSERT INTO student (name, gender, age, class_id) VALUES ('张三', '男', 7, 1), ('李四', '女', 8, 1), ('王五', '男', 7, 2), ('赵六', '女', 9, 3) | | 0.000 sec 成功插入四条记录 | | 4 | 23:56:08 | SELECT s.name, s.gender, s.age, c.name AS class_name FROM student s JOIN class c ON s.class_id = c.id WHERE s.age > 7 ORDER BY s.age DESC | | 0.000 sec 成功查询到两条记录 | | 5 | 23:56:09 | UPDATE student SET age = 10 WHERE name = '张三' | | 0.000 sec 成功更新一条记录 | | 6 | 23:56:10 | DELETE FROM student WHERE name = '赵六' | | 0.000 sec 成功删除一条记录 | | 7 | 23:56:11 | DROP TABLE student | | 0.000 sec 成功删除表student | | 8 | 23:56:12 | DROP TABLE class | | 0.000 sec 成功删除表class |