Bulk set Yoast SEO no-index for posts or custom post types

Insert this row into postmeta for each post ID:

INSERT INTO wp_postmeta (post_id,meta_key,meta_value) VALUES ({POST_ID},'_yoast_wpseo_meta-robots-noindex',1);