准备数据 CREATE DATABASE company; USE company; CREATE TABLE t_employee( id INT(4), name VARCHAR(20), gender VARCHAR(6), age INT(4), salary INT(6), deptno INT(4) ); INSERT INTO t_employee(id,name,gender,age,salary,deptno) VALUES(1001,'Alicia Florric'