[mythtvnz] KM R5E50 out, and MythMusic problems

[Hadley Rich]

On Tuesday 09 January 2007 15:02, Steve Hodge wrote:
> On 1/9/07, AlanP <alan.p@orcon.net.nz> wrote:
> > On a semi-related note, what's an easy way of deleting tons of rows from a
> > table without deleting the table at all? Because doing it through webmin
> > is
> > dead slow.
>
> delete from <tablename>;
>
> Not sure about wemin. I use sqlyog under Windows.

TRUNCATE TABLE tablename;

will be quicker if it's a table with a lot of data.

hads

-- 
http://nicegear.co.nz
New Zealand's VoIP Supplier