set foreign_key_checks =0;
ALTER TABLE table_name modify COLUMN id INT auto_increment;
set foreign_key_checks =1;
tips:
本文由wp2Blog导入,原文链接:http://devonios.com/mysql-%e4%b8%ad%e4%b8%bb%e9%94%ae%e8%a2%ab%e5%85%b6%e4%bb%96%e5%88%97%e5%bc%95%e7%94%a8%e6%97%b6%ef%bc%8c%e4%bf%ae%e6%94%b9%e4%b8%bb%e9%94%ae%e4%b8%ba%e8%87%aa%e5%a2%9e.html