您需要为此使用COALESCE()方法。语法如下:INSERT INTO yourTableName(yourColumnName1,yourColumnName2)
SELECT 1 + COALESCE((SELECT MAX(yourColumnName1) FROM yourTableName WHERE yourColumnName2=’yourValue’), 0), ’yourValue’;
为了理解上述语法,让我们创建一个表。创建表的查询如下:mysql> create table InsertMaxPlus1Demo
-> (
-> Id int,
-> Name varchar(20)
-> );
现在,您可以使用insert命令在表中插入一些记录。查询如下:mysql> insert into InsertMaxPlus1Demo(Id,Name) values(1,'John');
mysql> insert into InsertMaxPlus1Demo(Id,Name) values(1,'Mike');
mysql> insert into InsertMaxPlus1Demo(Id,Name) values(2,'John');
mysql> insert into InsertMaxPlus1Demo(Id,Name) values(1,'Larry');
mysql> insert into InsertMaxPlus1Demo(Id,Name) values(3,'John');
mysql> insert into InsertMaxPlus1Demo(Id,Name) values(2,'David'