mysql獲取指定表當前自增id值

weixin_30488085發表於2020-04-06
MySql

SELECT `AUTO_INCREMENT`
FROM  INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'database'
AND   TABLE_NAME   = 'log';

轉載於:https://www.cnblogs.com/112ba/p/6219353.html

相關文章