EPG addressing (1 Viewer)

ssenyer

MP Donator
  • Premium Supporter
  • December 22, 2010
    88
    10
    Tekirdağ
    Home Country
    Turkey Turkey
    For those who will need mysql query for duplicating the db rows here is the query

    SQL:
    INSERT INTO program (idChannel,startTime,endTime,title,description,seriesNum,episodeNum,genre,originalAirDate,classification,starRating,parentalRating,episodeName,episodePart,state)
    
    SELECT 319,startTime,endTime,title,description,seriesNum,episodeNum,genre,originalAirDate,classification,starRating,parentalRating,episodeName,episodePart,state
    
    FROM program
    
    WHERE idChannel=78;

    this query will copy all epg data of channel 78 to channel 319. You should change the channel numbers for as per your needs.
     

    Users who are viewing this thread

    Top Bottom