select ifnull(maxid, 1) as id from (select max(column_name) as maxid from table_name where [condition]) b;
其中1为指定输出的值,column_name为要查找最大值的列, table_name 为表名,condition为判断条件,b是给第二个select语句写了个别名,不写的话会出错。
select ifnull(maxid, 1) as id from (select max(column_name) as maxid from table_name where [condition]) b;
其中1为指定输出的值,column_name为要查找最大值的列, table_name 为表名,condition为判断条件,b是给第二个select语句写了个别名,不写的话会出错。