Skip to content

Instantly share code, notes, and snippets.

Created August 17, 2013 16:13
Show Gist options
  • Save anonymous/6257630 to your computer and use it in GitHub Desktop.
Save anonymous/6257630 to your computer and use it in GitHub Desktop.
Copy comment from mango blog to Mura.
INSERT INTO `muracms`.`tcontentcomments`
(commentId,contentId,comments,NAME,email,url,entered,isApproved,siteId)
SELECT
MC.id AS commentId,
MUT.contentId AS contentId,
MC.content AS comments,
MC.creator_name AS NAME,
MC.creator_email AS email,
MC.creator_url AS url,
MC.created_on AS entered,
MC.approved AS isApproved,
'yoursiteid' AS siteid
FROM `muracms`.`tcontent` AS MUT
INNER JOIN `mangodata`.`tblblogentry` AS MT ON MT.title = MUT.title AND MUT.`Active` = 1
INNER JOIN `mangodata`.tblblogcomment AS MC ON MT.ID = MC.entry_id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment