alter table blog_table auto_increment=500;
如果想用变量
就会报错
set @a=500;
alter table blog_table AUTO_INCREMENT=@a;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@a' at line 1
应该这样写:
SET @sql = CONCAT('ALTER TABLE `blog_table` AUTO_INCREMENT = ', @a);
PREPARE st FROM @sql;
EXECUTE st;