更新时间: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