On Monday 23 December 2002 22:21, Gordon wrote:
> DID DELETE FROM XXX with no where clause stop acting like truncate in
> 4.0.5?
>
> In 3.23.51 and earlier versions of 4.0.x
>
> mysql> delete from product_order_main;
> GIVES THIS
> Query OK, 0 rows affected (0.10 sec)
>
> AND RESETS THE AUTO
- Original Message -
From: "Gordon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, December 23, 2002 3:21 PM
Subject: DELETE with no WHERE clause
> DID DELETE FROM XXX with no where clause stop acting like truncate in
> 4.0.5?
>
> In 3.23.51 and e
DID DELETE FROM XXX with no where clause stop acting like truncate in
4.0.5?
In 3.23.51 and earlier versions of 4.0.x
mysql> delete from product_order_main;
GIVES THIS
Query OK, 0 rows affected (0.10 sec)
AND RESETS THE AUTOINCREMENT VALUE
mysql> insert into product_order_main values
(