Changing Auto-Increment Value
Posted 09 October 2006 - 07:32 PM
CREATE TABLE orders(
ID INT(5) AUTO_INCREMENT NOT NULL,
name VARCHAR(40) NOT NULL,
date DATE NOT NULL,
PRIMARY KEY(ID,date) )
I want to change the value of ID to 1 again after certain time. What MySQL query can I use to make the field ID begin autoincrementing from number 1 again. Thanks..
Posted 10 October 2006 - 12:32 AM
Posted 10 October 2006 - 12:52 AM
I haven't found anywhere on Google that suggests it is even possible but hopefully someone here will know!
Posted 10 October 2006 - 03:28 PM
Posted 10 October 2006 - 05:15 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users