[mythtv-users] SQL command to delete range of channels

[Aran Cox]

MySQL and phpMyAdmin go together like apple pie and ice cream.  I use it
all the time to delete entries from the oldrecorded table (when zap2it
got the program wrong or the HD filled up half way through a recording.)

Aran

On Fri, 2003-09-12 at 06:57, Keith C wrote:
> I haven't said anything yet, but does no one use a nice mySQL frontend
> like phpMyAdmin?  I used it to go through my channels and delete the
> ones I didn't want - all point and click.
> 
> I figured anyone using mySQL would have installed phpMyAdmin, but then
> again, I am a web geek.
> 
> Keith C
> 
> On Fri, 2003-09-12 at 02:57, Timothy.Weaver at at.redbull.com wrote:
> > 
> > 
> > I can use the SQL command found in the documentation to remove channels
> > individually from the database. Is there a command to remove a range of
> > channels?
> > 
> > In my situation, I want to remove everything over channel 99. If someone
> > can provide the general SQL command (if there is one) this would be great.
> > I assume it is a combination of a SELECT and a DELETE.
> > 
> > Perhaps Robert could then include this in the online documentation in the
> > section on how to remove channels.
> > 
> > 
> > ______________________________________________________________________
> > 
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 
> 
> ______________________________________________________________________
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users