建立信息表并插入数据员工(编号,姓名,性别,年龄,部门编号,年薪) 部门(编号,名称,人数,负责人) 项目(编号,名称,负责部门编号)
时间: 2024-05-07 08:23:40 浏览: 6
以下是建立信息表并插入数据的 SQL 语句:
创建员工表:
```
CREATE TABLE employee (
id INT PRIMARY KEY,
name VARCHAR(50),
gender CHAR(1),
age INT,
department_id INT,
salary DECIMAL(10,2)
);
```
插入员工数据:
```
INSERT INTO employee (id, name, gender, age, department_id, salary) VALUES
(1, '张三', 'M', 25, 1, 5000.00),
(2, '李四', 'M', 30, 2, 8000.00),
(3, '王五', 'F', 28, 1, 6000.00),
(4, '赵六', 'F', 35, 3, 10000.00),
(5, '钱七', 'M', 27, 2, 7000.00);
```
创建部门表:
```
CREATE TABLE department (
id INT PRIMARY KEY,
name VARCHAR(50),
num_of_employees INT,
manager VARCHAR(50)
);
```
插入部门数据:
```
INSERT INTO department (id, name, num_of_employees, manager) VALUES
(1, '开发部', 2, '张三'),
(2, '市场部', 2, '李四'),
(3, '财务部', 1, '赵六');
```
创建项目表:
```
CREATE TABLE project (
id INT PRIMARY KEY,
name VARCHAR(50),
department_id INT
);
```
插入项目数据:
```
INSERT INTO project (id, name, department_id) VALUES
(1, '项目A', 1),
(2, '项目B', 2),
(3, '项目C', 3);
```