distal-attribute
distal-attribute
distal-attribute
distal-attribute

'resetting' column

JamieEff posted 2 years ago in General
Hi there

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

Many thanks

Jamie
ansgar posted 2 years ago
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"
JamieEff posted 2 years ago
got it! thanks anse

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