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
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
- Orig
