SQL的简单操作

//建立数据库
CREATE DATABASE yuangong;
//建立数据库表
CREATE TABLE Employees(
employeesID INT,
NAME VARCHAR(100),
education VARCHAR(100),
biethday DATE,
sex INT,
workyear INT ,
address VARCHAR(100),
phonenumber INT,
departmentID INT);

//添加信息
INSERT INTO Employees VALUES (000001, ‘王林’, ‘大专’, ‘1996-01-23’, 1, 8, ‘中山路32-1-508’, 83355668 ,2),
(010008, ‘伍熔华’, ‘本科’, ‘1976-03-28’, 1, 3, ‘北京东路100-2’, 833211321, 1),
(020010, ‘王向荣’, ‘硕士’, ‘1982-12-09’, 1, 2, ‘四排路10-0-108’, 83792361, 1),
(020018, ‘李丽’, ‘大专’, ‘1960-07-30’, 0, 6, ‘中山东路102-2’, 83413301, 1),
(102201, ‘刘明’, ‘本科’, ‘1972-10-18’, 1, 3, ‘虎踞路100-2’, 83606608, 5),
(102208, ‘朱骏’, ‘硕士’, ‘1965-09-28’, 1, 2, ‘牌楼巷5-3-106’, 84708817, 5),
(108991, ‘钟敏’, ‘硕士’, ‘1979-08-10’, 0, 4, ‘中山路10-3-105’, 883346722, 3),
(111006, ‘张石兵’, ‘本科’, ‘1974-10-01’, 1, 1, ‘解放路34-1-203’, 84563418, 5),
(210678, ‘林涛’, ‘大专’, ‘1977-04-02’, 1, 2, ‘中山北路