'resetting' column

25 posts
[expired user #6753]'s profile image [expired user #6753] posted 11 years ago in General Permalink
Hi there

Just wondering how I would 'reset' a columns ID to 0 ?

Many thanks

Jamie
10152 posts
ansgar's profile image ansgar posted 11 years ago Permalink
You mean, if a table has 0 rows, start at 0 again with the first next row you insert? That's easy in HeidiSQL:
* Doubleclick/open the table, tab "Table: xyz"
* Go to the "Options" tab
* Set the "Auto increment" value to "0"
25 posts
[expired user #6753]'s profile image [expired user #6753] posted 11 years ago Permalink
got it! thanks anse

Please login to leave a reply, or register at first.