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 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)
Yes, it's expected behaviour for 3.23.xx version of MySQL server , but not for
4.0.x:
http://www.mysql.com/doc/en/News-4.0.0.html
> USING 4.0.5 I GET
[skip]
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
