mysql中如何用一条语句更新主键增加特定的值

最新推荐文章于 2024-07-22 03:02:27 发布

aoerqileng

最新推荐文章于 2024-07-22 03:02:27 发布

阅读量1.9k

点赞数

分类专栏： MYSQL

本文链接：https://blog.csdn.net/aoerqileng/article/details/80924782

版权

MYSQL 专栏收录该内容

274 篇文章 2 订阅

订阅专栏

mysql> select * from bai_utf8;
+-----+--------+
| id  | myname |
+-----+--------+
|   1 | aa     |
| 100 | ab     |
| 200 | cc     |
| 300 | dd     |
| 400 | ee     |
| 500 | ff     |
+-----+--------+
6 rows in set (0.00 sec)

mysql> show create table bai_utf8;
+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table    | Create Table                                                                                                                                                                                                                   |
+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| bai_utf8 | CREATE TABLE `bai_utf8` (
  `id` int(11) NOT NULL,
  `myname` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_name` (`myname`),
  UNIQUE KEY `u_name2` (`myname`(10))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 |
+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> update bai_utf8 set id=id+100;
ERROR 1062 (23000): Duplicate entry '200' for key 'PRIMARY'
mysql> update bai_utf8 set id=id+100 order by id desc;
Query OK, 6 rows affected (0.02 sec)
Rows matched: 6  Changed: 6  Warnings: 0