I can not confirm this, but it would make sense that this was updated in 4.05. After all, you are only deleting your records, not re-building the table. The new functionality you describe is also present in SQL Server and Oracle.
Filter: Mysql , sql , query Good Luck, Dennis Salguero ----- 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 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 > (null,'rcl1','hh','ab','pending','yes','20021223',now()); > Query OK, 1 row affected (0.10 sec) > > mysql> select * from product_order_main; > +---------+---------+---------+---------+-------------+-------------+--- > -------------+---------------------+ > | ordr_ID | cpny_ID | prod_ID | acct_ID | pord_Status | pord_Active | > pord_Timestamp | pord_Create | > +---------+---------+---------+---------+-------------+-------------+--- > -------------+---------------------+ > | 1 | rcl1 | hh | ab | Pending | Yes | > 20021223000000 | 2002-12-23 11:14:18 | > +---------+---------+---------+---------+-------------+-------------+--- > -------------+---------------------+ > 1 row in set (0.10 sec) > > xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx > xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx > > USING 4.0.5 I GET > > mysql> delete from product_order_main; > Query OK, 1 row affected (0.00 sec) > > mysql> insert into product_order_main values > (null,'rcl1','hh','ab','pending','yes','20021223',now()); > Query OK, 1 row affected (0.00 sec) > > mysql> select * from product_order_main; > +---------+---------+---------+---------+-------------+-------------+--- > -------------+---------------------+ > | ordr_ID | cpny_ID | prod_ID | acct_ID | pord_Status | pord_Active | > pord_Timestamp | pord_Create | > +---------+---------+---------+---------+-------------+-------------+--- > -------------+---------------------+ > | 225 | rcl1 | hh | ab | Pending | Yes | > 20021223000000 | 2002-12-23 11:19:10 | > +---------+---------+---------+---------+-------------+-------------+--- > -------------+---------------------+ > 1 row in set (0.00 sec) > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php