九块钱的代码:p 53 按照上面的写的,CREATE TABLE emp(
id INT PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(30),
age INT,
dep_name VARCHAR(20),
dep_location VARCHAR(30)
);
INSERT INTO emp(NAME,age,dep_name,dep_location) VALUES('张三',18,'研发部','贵州');
INSERT INTO emp(NAME,age,dep_name,dep_location) VALUES('刘四',18,'研发部','北京');
INSERT INTO emp(NAME,age,dep_name,dep_location) VALUES('王五',18,'研发部','上海');
INSERT INTO emp(NAME,age,dep_name,dep_location) VALUES('张为',18,'研发部','贵州');
INSERT INTO emp(NAME,age,dep_name,dep_location) VALUES('阿斯顿',18,'研发部','上海');
INSERT INTO emp(NAME,age,dep_name,dep_location) VALUES('阿瑟东',22,'研发部','贵州');
INSERT INTO emp(NAME,age,dep_name,dep_location) VALUES('东梅尔',40,'研发部','贵州');