能给出具体操作语句吗?
时间: 2023-08-18 15:06:24 浏览: 44
好的,下面给出MySQL语句,实现工资管理系统的数据库操作:
1. 添加员工信息
```sql
INSERT INTO employee (id, name, gender, hire_date, department_id, position, salary) VALUES ('001', '张三', '男', '2021-01-01', '001', '经理', 10000);
```
2. 修改员工信息
```sql
UPDATE employee SET name='李四', position='部门经理' WHERE id='001';
```
3. 删除员工信息
```sql
DELETE FROM employee WHERE id='001';
```
4. 添加部门信息
```sql
INSERT INTO department (id, name) VALUES ('001', '销售部');
```
5. 修改部门信息
```sql
UPDATE department SET name='市场部' WHERE id='001';
```
6. 删除部门信息
```sql
DELETE FROM department WHERE id='001';
```
7. 发放工资
```sql
INSERT INTO salary (id, employee_id, salary_date, salary) VALUES ('001', '001', '2021-01-31', 10000);
```
8. 查看员工工资信息
```sql
SELECT employee.id, employee.name, salary.salary_date, salary.salary FROM employee INNER JOIN salary ON employee.id=salary.employee_id WHERE employee.id='001';
```
9. 查看部门工资信息
```sql
SELECT department.name, SUM(salary.salary) AS total_salary FROM employee INNER JOIN department ON employee.department_id=department.id INNER JOIN salary ON employee.id=salary.employee_id GROUP BY department.id;
```
以上为示例操作语句,实际使用时需要根据具体需求进行修改。
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)