- Thread starter
- #11
For those who will need mysql query for duplicating the db rows here is the query
this query will copy all epg data of channel 78 to channel 319. You should change the channel numbers for as per your needs.
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.