# Time Action Message Duration Fetch0 1 235604 CREATE TABLE student id INT PRIMARY KEY AUTO_INCREMENT name VARCHAR50 NOT NULL gender ENUM男 女 NOT NULL age INT NOT NULL class_id INT NOT NULL

1 2 23:56:05 CREATE TABLE class ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50) NOT NULL ) 0.000 sec 成功创建表class 2 3 23:56:06 INSERT INTO class (name) VALUES ('一年级'), ('二年级'), ('三年级') 0.000 sec 成功插入三条记录 3 4 23:56:07 INSERT INTO student (name, gender, age, class_id) VALUES ('张三', '男', 7, 1), ('李四', '女', 8, 1), ('王五', '男', 7, 2), ('赵六', '女', 9, 3) 0.000 sec 成功插入四条记录 4 5 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 6 23:56:09 UPDATE student SET age = 10 WHERE name = '张三' 0.000 sec 成功更新一条记录 6 7 23:56:10 DELETE FROM student WHERE name = '赵六' 0.000 sec 成功删除一条记录 7 8 23:56:11 DROP TABLE student 0.000 sec 成功删除表student 8 9 23:56:12 DROP TABLE class 0.000 sec 成功删除表class