Re: AUOT_INCREMENT from the beginning

2002-07-01 Thread Victoria Reznichenko
César, Thursday, June 27, 2002, 8:41:25 PM, you wrote: CA> Hi all. I have multiple tables in which I need to delete rows from the CA> beginning. I have them stored with an auto_increment id but I don't want CA> the records to start from 5 but from 1... is there a way to use CA> something like ALT

RE: AUOT_INCREMENT from the beginning

2002-06-27 Thread Roma Gupta
, 2002 1:41 PM To: MySQL General Subject: AUOT_INCREMENT from the beginning Hi all. I have multiple tables in which I need to delete rows from the beginning. I have them stored with an auto_increment id but I don't want the records to start from 5 but from 1... is there a way to use something

AUOT_INCREMENT from the beginning

2002-06-27 Thread César Aracena
Hi all. I have multiple tables in which I need to delete rows from the beginning. I have them stored with an auto_increment id but I don't want the records to start from 5 but from 1... is there a way to use something like ALTER TABLE tablename AUTO_INCREMENT = 1; but also that will make the count