-
is it possible to reset AUTO_INCREMENT?
i was wondering if it was possible to reset the increment back to 0, once all the data in the table is deleted??
thanks in advance
g
-
If you delete everything without a filter, it should automatically be reset back to 0. Otherwise, use the following:
ALTER TABLE TableName AUTO_INCREMENT=0
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|