INSERTINTO wp_postmeta (post_id, meta_key, meta_value) SELECT ID AS post_id, ‘UniversalCustomField’ AS meta_key ‘MyValue AS meta_value FROM wp_postsWHERE ID NOTIN (SELECT post_id FROM wp_postmeta WHERE meta_key = ‘UniversalCustomField’)
如果只需要为文章添加自定义字段,可以使用下面这段代码:
INSERTINTO wp_postmeta (post_id, meta_key, meta_value) SELECT ID AS post_id, ‘UniversalCustomField’ AS meta_key ‘MyValue AS meta_value FROM wp_posts WHERE ID NOTIN (SELECT post_id FROM wp_postmeta WHERE meta_key = ‘UniversalCustomField’)“ AND post_type = ‘post’;
如果只需要为页面添加自定义字段,可以使用下面这段代码:
INSERTINTO wp_postmeta (post_id, meta_key, meta_value) SELECT ID AS post_id, ‘UniversalCustomField’ AS meta_key ‘MyValue AS meta_value FROM wp_posts WHERE ID NOTIN (SELECT post_id FROM wp_postmeta WHERE meta_key = ‘UniversalCustomField’)AND `post_type` = ‘page’;