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
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