Re: Resetting the auto_increment to start from 1

2003-01-09 Thread Stefan Hinz, iConnect \(Berlin\)
: Fixed Rows: 0 Avg_row_length: 0 Data_length: 16384 Max_data_length: NULL Index_length: 0 Data_free: 0 Auto_increment: 1 Create_time: NULL Update_time: NULL Check_time: NULL Create_options: Comment: InnoDB free: 14336 kB > >Regards

Re: Resetting the auto_increment to start from 1

2003-01-09 Thread Octavian Rasnita
- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Octavian Rasnita" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 9:26 PM Subject: Re: Resetting the auto_increment to start from 1 At 9:33 +0200 1/8/03, Octavian Ra

Re: Resetting the auto_increment to start from 1

2003-01-08 Thread Paul DuBois
de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Octavian Rasnita" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 8:33 AM Subject: Resetting the au

Re: Resetting the auto_increment to start from 1

2003-01-08 Thread Stefan Hinz, iConnect \(Berlin\)
Message - From: "Octavian Rasnita" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 8:33 AM Subject: Resetting the auto_increment to start from 1 > Hi all, > > I've read the following in a MySQL book: > >

Re: Resetting the auto_increment to start from 1

2003-01-08 Thread Paul DuBois
At 9:33 +0200 1/8/03, Octavian Rasnita wrote: Hi all, I've read the following in a MySQL book: A special case of record deletion occurs when you clear out a table entirely using a DELETE with no WHERE clause: DELETE FROM tbl_name; In this case, the sequence counter may be reset to 1, even f

Resetting the auto_increment to start from 1

2003-01-08 Thread Octavian Rasnita
Hi all, I've read the following in a MySQL book: A special case of record deletion occurs when you clear out a table entirely using a DELETE with no WHERE clause: DELETE FROM tbl_name; In this case, the sequence counter may be reset to 1, even for table types for which values normally are no