将MAX(col)+1插入相同的MySQL表中？
让我们首先创建一个表-
mysql> create table DemoTable1484 -> ( -> Id int -> );
使用插入命令在表中插入一些记录-
mysql> insert into DemoTable1484 values(100); mysql> insert into DemoTable1484 values(175); mysql> insert into DemoTable1484 values(165); mysql> insert into DemoTable1484 values(145); mysql> insert into DemoTable1484 values(170);
使用select语句显示表中的所有记录-
mysql> select * from DemoTable1484;
这将产生以下输出-
+------+ | Id | +------+ | 100 | | 175 | | 165 | | 145 | | 170 | +------+ 5 rows in set (0.00 sec)
这是将MAX(col)+1插入同一表的查询-
mysql> insert into DemoTable1484(Id) select max(Id)+1 from DemoTable1484; Records: 1 Duplicates: 0 Warnings: 0
让我们再次检查表记录-
mysql> select * from DemoTable1484;
这将产生以下输出。新值成功插入-
+------+ | Id | +------+ | 100 | | 175 | | 165 | | 145 | | 170 | | 176 | +------+ 6 rows in set (0.00 sec)