且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在MySQL中重置表的自动增量列

更新时间:2023-02-20 23:29:12

我不确定是否收到您的问题,但是如果您希望对列sl重新编号,请先执行ALTER TABLE your_table DROP sl,然后再执行ALTER TABLE your_table ADD sl your_definitions >

I have a table and it's first column sl is auto incrementing. After populating my table, I removed first two rows, and the first entry is having sl 1. Is it possible to reset it to 1 maintaining AI? I am using PHP MyAdmin.

I'm not sure if i got your question but if you want your column sl to be renumbered do ALTER TABLE your_table DROP sl and then ALTER TABLE your_table ADD sl your_definitions