mysql initialvalue_如何在MySQL中設置初始值和自動增量?

29

MySQL Workbench

MySQL工作台

If you want to avoid writing sql, you can also do it in MySQL Workbench by right clicking on the table, choose "Alter Table ..." in the menu.

如果您想避免編寫sql，也可以在MySQL Workbench中通過右鍵單擊該表，在菜單中選擇“Alter table…”。

When the table structure view opens, go to tab "Options" (on the lower bottom of the view), and set "Auto Increment" field to the value of the next autoincrement number.

當表結構視圖打開時，轉到選項卡“Options”(在視圖的底部)，並將“自動增量”字段設置為下一個自動增量數字的值。

Don't forget to hit "Apply" when you are done with all changes.

當您完成所有更改時，不要忘記點擊“Apply”。

PhpMyAdmin:

PhpMyAdmin:

If you are using phpMyAdmin, you can click on the table in the lefthand navigation, go to the tab "Operations" and under Table Options change the AUTO_INCREMENT value and click OK.

如果您正在使用phpMyAdmin，可以單擊左側導航中的表，轉到“Operations”選項卡，在“table Options”下更改AUTO_INCREMENT值並單擊OK。