[Phpmyadmin-devel] TRUNCATE instead of DELETE

Marc Delisle DelislMa at CollegeSherbrooke.qc.ca
Mon Apr 22 12:08:18 CEST 2002


good idea.  However is it possible to check for locks:
"Not transaction-safe; you will get an error if you have an active transaction or an active table
lock. "

Rabus a écrit :
> Hello list,
> If you let me, I'd modify the code to use TRUNCATE instead of DELETE when
> emptying tables if MySQL 4 is used since this is a much faster way:
> The DELETE command deletes the table content row by row while TRUNCATE drops
> and recreates the table.
> Some doc about this: http://www.mysql.com/doc/T/R/TRUNCATE.html
> Alexander
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

Marc Delisle

More information about the Developers mailing list