[mythtvnz] KM R5E50 out, and MythMusic problems
Steve Hodge
mythtvnz@lists.linuxnut.co.nz
Tue, 9 Jan 2007 22:31:12 +1300
------=_Part_51174_2255742.1168335072076
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
On 1/9/07, Hadley Rich <mythtvnz@nice.net.nz> wrote:
>
> 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.
>
I use truncate with Oracle - I didn't know mysql supported it.
Steve
------=_Part_51174_2255742.1168335072076
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
On 1/9/07, <b class="gmail_sendername">Hadley Rich</b> <<a href="mailto:mythtvnz@nice.net.nz">mythtvnz@nice.net.nz</a>> wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Tuesday 09 January 2007 15:02, Steve Hodge wrote:<br>> On 1/9/07, AlanP <<a href="mailto:alan.p@orcon.net.nz">alan.p@orcon.net.nz</a>> wrote:<br>> > On a semi-related note, what's an easy way of deleting tons of rows from a
<br>> > table without deleting the table at all? Because doing it through webmin<br>> > is<br>> > dead slow.<br>><br>> delete from <tablename>;<br>><br>> Not sure about wemin. I use sqlyog under Windows.
<br><br>TRUNCATE TABLE tablename;<br><br>will be quicker if it's a table with a lot of data.<br></blockquote></div><br>I use truncate with Oracle - I didn't know mysql supported it.<br><br>Steve<br>
------=_Part_51174_2255742.1168335072076--