mysql - MySQL SET 查询中的引用字段

Question

所以我有一张看起来像这样的 table

+----+----------------------+--------------------------+----------+----------+
| id | fullname             | email                    | username | password |
+----+----------------------+--------------------------+----------+----------+
|  1 | John Doe             | johndoe@example.com      | johndoe  | password |
|  2 | Jane Doe             | janedoe@example.com      | janedoe  | password | 
+----+----------------------+--------------------------+----------+----------+

我想做的是将“密码”更改为“1”。例如，在该查询之后该表将如下所示:

+----+----------------------+--------------------------+----------+----------+
| id | fullname             | email                    | username | password |
+----+----------------------+--------------------------+----------+----------+
|  1 | John Doe             | johndoe@example.com      | johndoe  | johndoe1 |
|  2 | Jane Doe             | janedoe@example.com      | janedoe  | janedoe1 | 
+----+----------------------+--------------------------+----------+----------+

我尝试执行 UPDATE table SET password=username+"1"WHERE id=1; 但这没有用。不足为奇。

我该怎么做？

Answer 1

使用concat

UPDATE table SET password=CONCAT(username,'1') ;

Demo