I am trying to add custom commentmeta "likes" with 0 as default value to every posted comment. I have this query but I dont see any error there, but still it doesnt work. Can anyone help me to solve this issue? :) thanks!
INSERT INTO wp_commentmeta( comment_id, meta_key, meta_value ) SELECT comment_ID, 'likes' AS meta_key, 0 AS meta_value FROM wp_comments WHERE comment_approved = '1'