如何在MySQL中重置AUTO_INCREMENT？

本文翻译自：How to reset AUTO_INCREMENT in MySQL?

How can I reset the AUTO_INCREMENT of a field? 如何重置字段的AUTO_INCREMENT ？ I want it to start counting from 1 again. 我希望它再次从1开始计数。

---

#1楼

参考：https://stackoom.com/question/bRJC/如何在MySQL中重置AUTO-INCREMENT

---

#2楼

I suggest you to go to Query Browser and do the following: 我建议您转到查询浏览器并执行以下操作：

1. Go to schemata and find the table you want to alter. 转到纲要，找到要更改的表。
2. Right click and select copy create statement. 右键单击并选择复制创建语句。
3. Open a