一、mysql中查询自增id的下一个值
-- 查询自增id的下一个值
SELECT
AUTO_INCREMENT
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_NAME = '{table name}'
使用中替换掉表名即可,表名需要用引号引起来
例如
SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = 'dict_type'
二、mysql多个schema查询自增id的下一个值
SELECT
AUTO_INCREMENT
FROM
INFORMATION_SCHEMA. TABLES
WHERE
Table_Schema='{schema}' and
TABLE_NAME = '{table name}'
替换掉schema与table name的值,且用引号引起来
例:
SELECT
AUTO_INCREMENT
FROM
INFORMATION_SCHEMA. TABLES
WHERE
Table_Schema='ltsy' and
TABLE_NAME = 'dict_type'