LOCK_TABLES i TRUNCATE, czy da sie sprawic by TRUNCATE dzialalo Opcje

[sobstel]

wykonanie ponizszeg kodu

[PHP] pobierz, plaintext 
<?php
 
mysql_query('LOCK TABLES table WRITE');	  
mysql_query('TRUNCATE TABLE table');
mysql_query('UNLOCK TABLES');
 
?>
[PHP] pobierz, plaintext 

skutkuje wystapieniem nastepujacego bledu :

Fatal error: 1192:Can't execute the given command because you have active locked tables or an active transaction


Czy jest jakis sposob na uzycie TRUNCATE po zablokowaniu tabeli?

[markac]

TRUNCATE TABLE differs from DELETE FROM ... in the following ways:

Truncate operations drop and re-create the table, which is much faster than deleting rows one by one.
Not transaction-safe; you will get an error if you have an active transaction or an active table lock.
Doesn't return the number of deleted rows.
As long as the table definition file `table_name.frm' is valid, the table can be re-created this way, even if the data or index files have become corrupted.

Mam nadzieję, że to trochę rozjaśniło sytuację (IMG:http://forum.php.pl/style_emoticons/default/cool.gif)