MySQL编辑和更新记录，包括员工工资

UPDATE命令在MySQL中用于更新记录。通过它，SET命令可用于设置新值。让我们首先创建一个表-

mysql> create table DemoTable
(
   EmployeeId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
   EmployeeName varchar(50),
   EmployeeSalary int
);

使用插入命令在表中插入一些记录-

mysql> insert into DemoTable(EmployeeName,EmployeeSalary) values('Chris',56780);
mysql> insert into DemoTable(EmployeeName,EmployeeSalary) values('Robert',45670);
mysql> insert into DemoTable(EmployeeName,EmployeeSalary) values('Mike',87654);
mysql> insert into DemoTable(EmployeeName,EmployeeSalary) values('David',34569);

使用select语句显示表中的所有记录-

mysql> select *from DemoTable;

这将产生以下输出-

+------------+--------------+----------------+
| EmployeeId | EmployeeName | EmployeeSalary |
+------------+--------------+----------------+
|          1 | Chris        |          56780 |
|          2 | Robert       |          45670 |
|          3 | Mike         |          87654 |
|          4 | David        |          34569 |
+------------+--------------+----------------+
4 rows in set (0.00 sec)

以下是更新记录和设置新值的查询-

mysql> update DemoTable
   set EmployeeSalary=EmployeeSalary+12346;
Rows matched: 4 Changed: 4 Warnings: 0

让我们检查表记录-

mysql> select *from DemoTable;

这将产生以下输出-

+------------+--------------+----------------+
| EmployeeId | EmployeeName | EmployeeSalary |
+------------+--------------+----------------+
|          1 | Chris        | 69126          |
|          2 | Robert       | 58016          |
|          3 | Mike         | 100000         |
|          4 | David        | 46915          |
+------------+--------------+----------------+
4 rows in set (0.00 sec)