employee.sql

来自「J2EE独立开发制作」· SQL 代码 · 共 8 行

CREATE DATABASE company;
use company;
CREATE TABLE employee(id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,name VARCHAR(80) NOT NULL,
email VARCHAR(80) NOT NULL,address VARCHAR(80) NOT NULL);
INSERT INTO employee(name,email,address) VALUES ('sun','[e-mail]','QingDao');
INSERT INTO employee(name,email,address) VALUES ('bin','[e-mail]','BeiJing');
INSERT INTO employee(name,email,address) VALUES ('zhu','[e-mail]','ShangHai');