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
You can try two easy things... Truncate table table_name (this happen to be syntax of sql server, you can check if Mysql supports it) Second you can drop table and generate it again.. :) Roma -Original Message- From: César Aracena [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 27, 20