Insert all post IDs in new database table

Like so:

INSERT INTO $mytable (post_id)
SELECT ID
FROM $wpdb->posts as posts
LEFT JOIN $mytable as dup_check
ON dup_check.post_id = posts.ID
WHERE dup_check.post_id IS NULL;

Related Posts:

  1. Build a content and excerpt grid loop with paging and options for # of posts
  2. Change the footer text on the login page
  3. How to remove a metabox from menu editor page?
  4. Check if page parent has certain template
  5. Delete post revisions on post publish
  6. Hooking new functions to actions + passing parameters
  7. Is $hook a global variable in WordPress
  8. Is the regular ajax request method safe or I should use admin-ajax.php?
  9. Successful or Error Message after running mysql code in functions.php
  10. PHP code inside shortcodes
  11. Randomise upload filenames (or another solution to hide the original image URL from theft?)
  12. Handling Body class based on Template
  13. WSoD being caused by this piece of code
  14. Logged in user ID as post ID
  15. How to check if a meta value has already been assigned to any user?
  16. WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
  17. Woocommerce: hook action/filter I could use to add variation id and price with each attribute opt on WooCommerce Rest api
  18. Why ajax doesn’t work on certain wordpress hooks?
  19. Is it possible to intercept all ajax requests and get the parameters and the returns?
  20. WordPress Gravatar filter is removing my custom attributes
  21. Error in custom php function doesn’t exist
  22. Generating an nonce for Content Security Policy and all scripts – How to make it match/persist for each page load?
  23. Return a numerical function value in Customizer controls
  24. Modify custom field input data before creating a new post
  25. how to make custom ajax handler?
  26. $wpdb->wp_users returning empty value for
  27. How to list posts from a plugin taxonomy?
  28. Omit custom post type from wp-sitemap.xml based on meta key using wp_sitemaps_posts_query_args
  29. Multiple meta_key in one global $wpdb;
  30. Run a code only on theme activation only during first activation
  31. Pagination broken on is_front_page()
  32. Theme not calling Jquery properly
  33. WordPress redirect redirecting too many times or not at all
  34. Why does the post_type_link hook everything twice?
  35. Issue with fetching mysql data and displaying results via shortcode in webpage
  36. How to have different site identity logos on each page on Astra Theme [closed]
  37. How can I hook into the wp_mail function used by BackWPup?
  38. change the default order of posts only for specific categories
  39. Get user custom field value on function.php
  40. How to use mysql LIKE with wpdb?
  41. Adding function to child theme’s function.php
  42. Must filter functions receive all arguments passed to them?
  43. Creating customized php files in theme folder
  44. Dynamically Generate Functions and Hooks
  45. How to pass hook variable to function?
  46. making php value numeric
  47. SQL error with custom query
  48. Modify WooCommerce used to get all orders in dashboard
  49. How do I add a function to parent theme
  50. Contain multiple page templates in one PHP custom template file in WordPress?
  51. Wp_Schedule_Event every few minutes doesn’t work
  52. Adding custom field to product category and show it to shop/category shop page
  53. Custom meta box is not displaying value showing tag as empty
  54. Discount in the specific product title using keyword ( Woocoommerce )
  55. How do I get the value of a current user’s custom field?
  56. Hook into all password resets in WordPress and get password before hashing?
  57. Getting page / post URL on publish and / or update
  58. Fatal error when using array_diff() function inside of wp_update_nav_menu hook?
  59. Why transition_post_type hook is called twice for the same post?
  60. How can I display a query in a page?
  61. How to set up an auto delete post?
  62. WordPress HTML Helper
  63. Custom query_posts() parameter
  64. How to modify this function to exclude also the post belonging to a specific category?
  65. Assign new post author IF another user in custom field on post transition
  66. Create and publish a new post every Monday, listing the post titles and links to the posts published during the previous week
  67. transition_post_status hook, works – but not if the post is new
  68. /page/2/ redirect to 404
  69. Is there a hook that I can use when a fatal error occurs?
  70. Fatal error: Call to undefined function mysql_connect()
  71. How to Add Image to WordPress RSS-Feed with no Plug-in?
  72. How to add active class to custom menu using while loop and wp_list_pages
  73. Cleanest/Fastest way to avoid calling and retrieving data from the database multiple times?
  74. WooCommerce – Display variation custom field value [closed]
  75. Woocommerce HTML email option unavailable
  76. Use template for posts with a particular category grandparent
  77. WordPress Redirect: Default Password Reset URL [duplicate]
  78. Remove an action hook within a Class
  79. Contact Fom 7 – how to add custom HTML inside span.wpcf7-form-control-wrap AND IMMEDIATELY AFTER input.wpcf7-form-control?
  80. Add .htm extention to a custom taxonomy
  81. Custom gallery in wp3.5
  82. How to use theme function in post/page?
  83. esc_url( ) won’t use https
  84. Use post ID in functions.php file adminside
  85. How can I count ACF sub_field with a certain value
  86. Custom posts password protect
  87. Using Ajax to submit a form, and run a SQL Select query based on user input from the form
  88. Woocommerce – Exclude variation attribute on specific variation
  89. call to undefined function mysql_connect
  90. Show data obtained from a function and place it in a shortocode function
  91. Delete empty title_tags, find a h1 heading and echo it
  92. WP_Query To Display Product Of Brand On Taxonomy Page
  93. Search for images that width and height is more than 500
  94. wordpress ajax return 0
  95. My customizer’s setting doesn’t set to the default and needed to click the control’s “Default” button before it’ll be set
  96. Overwriting a Shortcode
  97. MySQL database migration to WordPress
  98. What is the wrong with this function to enqueue the scripts and styles to the theme? [closed]
  99. Putting form result in my database
  100. How can I update a value of a field depending on outside source?