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
