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

'resetting' column

User, date Message
Written by JamieEffMoney, Euro
2 years ago
Category: General
25 posts since Wed, 09 Jan 13
Hi there

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

Many thanks

Jamie
Written by ansgar
2 years ago
4955 posts since Fri, 07 Apr 06
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"
Written by JamieEffMoney, Euro
2 years ago
25 posts since Wed, 09 Jan 13
got it! thanks anse
 

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