ot;Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>; "Octavian
Rasnita" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 1:49 AM
Subject: Re: Resetting the auto_increment to start from 1
At 20:39 +0100 1/8/03, Stefan Hinz, iCo
-
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
At 20:39 +0100 1/8/03, Stefan Hinz, iConnect (Berlin) wrote:
Octavian,
I've read the following in a MySQL book:
It's a rather old book, which deals with MySQL 3.23, and not with MySQL
4.x.
Actually, he's talking about MySQL Cookbook (p549). Which is a new book,
which is why I said *may* re
Octavian,
> I've read the following in a MySQL book:
It's a rather old book, which deals with MySQL 3.23, and not with MySQL
4.x.
> DELETE FROM tbl_name WHERE 1 > 0;
In MySQL 3.23, this was a workaround to force the server to delete a
table row by row. By default, 3.23 would on DELETE FROM tbl
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
