Mysql addition, deletion, modification and query update records

Update record

Update data We have already said. When you need to modify content, modify bank card balances, or modify equipment information, you need to use update and modify statements.

The basic syntax of the modification (also called update) statement is as follows:

Suppose we have the following table, the table structure is as follows:

mysql> select * from emp where deptno=15;
+------+----------+----------+
| userid |username|  balance |
+------+----------+----------+
| 15   |  马云    | 15000.00 |
+------+-------+-------------+
1 row in set (0.00 sec)

使用 update 语句进行记录更新

mysql>  update money set  balance=balance-500 where userid = 15;
 Query OK, 1 row affected (0.35 sec)
 Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from emp where deptno=15;
 +------+----------+----------+
 | userid |username|  balance |
 +------+----------+----------+
 | 15   |  马云    | 14500.00 |
 +------+-------+-------------+
 1 row in set (0.00 sec)

修改多个字段

mysql> update money set  balance=balance-500,username='李文凯' where userid = 15;
 Query OK, 1 row affected (0.00 sec)
 Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from emp where deptno=15;
 +------+----------+----------+
 | userid |username|  balance |
 +------+----------+----------+
 | 15   |王宝强    | 14500.00 |
 +------+-------+-------------+
 1 row in set (0.00 sec)

同时对两个表进行更新

mysql> update money m,user u m.balance=m.balance*u.age where m.userid=u.id;