employee.sql

J2EE独立开发制作

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');