load post data into mysql

I’m not sure of having understood what you are asking for. But if my guess is correct, you can achieve this goal by using $wpdb global variable.

But, in order to be more specific, I need to know how and when you want the database to update those informations.

Related Posts:

  1. MySQL Query to Retrieve Category from wp_posts
  2. SQL Query for getting all posts in their latest revised state
  3. Search & Remove Specific Shortcode From All Posts
  4. Manually delete post from database
  5. How to force update all posts after import
  6. Query All users that has post
  7. Can’t publish new posts
  8. Manually removing revision post types
  9. Reset/Reorder posts ID in the MySQL wp_posts table
  10. How do I find which articles are missing a featured image in The WordPress database?
  11. Tags to Post-ID mysql query. Tag Search
  12. wp_insert_post – duration
  13. Get user categories with most posts in it
  14. MySql query to get posts with all meta and terms
  15. Custom order for Mysql array
  16. List authors with the last post title and order by last post date
  17. How to Mysql select a list of posts with meta_values AND all relevant categories?
  18. Remove a shortcode from all WordPress posts
  19. Order posts alphabetically: how to set order=asc in mysql query?
  20. What do these phpMyAdmin errors mean on my WordPress databaes?
  21. What happens if I delete all the rows that represents a post revision from the posts table into WordPress database?
  22. Delete post results in “Cannot delete or update a parent row: a foreign key constraint fails”
  23. Inner join overrides Advanced Custom Fields plugin’s get_field [closed]
  24. update image path with words starting uppercase to lowercase chars
  25. Queries take 120+ seconds on my large WordPress site
  26. Database hacked – random posts are modified
  27. Need to change all links in page content but not in post content
  28. Can’t update WordPress Page if post_content is Empty
  29. Restore woocommerce orders
  30. How to select particular month post from table and update the post status using MySQL?
  31. How do post IDs work in WordPress?
  32. Get author posts count after excluding a category
  33. get last post’s link with SQL query
  34. query for filtering published posts?
  35. MySQL: Possible to replace all of wp_posts.post_content(id#) via UPDATE + REPLACE + SELECT?
  36. Deleting post tags removes categories
  37. Return records between two meta datetimes saved as strings
  38. WP query taxonomy optimization
  39. MYSQL: Create SQL query to search for string and replace
  40. Query to fetch custom taxonomy along with post title
  41. Mysql update menu_order problem
  42. Bulk find & replace on WordPress posts/pages (minus image paths)
  43. WordPress MySQL Search and replace with wildcard?
  44. Add postmeta to all blog posts
  45. ‘posts’ table should not store the absolute image path
  46. Dev and prod on the same database- dev version active for IOS
  47. SQL trigger failes with post_content
  48. Converting Posts to Pages
  49. How to change the publishing date of each posts?
  50. SQL query to remove first image in all posts
  51. Delete junk text from all the post using my sql command
  52. FIND and REPLACE wp_posts AND IGNORE custom post type mysql query
  53. How to create a post based on data in a table?
  54. If meta_key exists then don’t select this post?
  55. How to update wp_posts with just the returned comment count from wp_comments (SQL GROUP BY)
  56. Count how many posts in category
  57. Adding Post Counts to Menu (Nav) Programmatically?
  58. Show chart in post using data passed as custom field
  59. Show One Category on Post
  60. Creating new page with pre-defined parent page
  61. Get all Youtube video’s from posts and embed them on a different page
  62. Send email to user that his post has been rejected
  63. How can I highlight syntax like it appears on stackoverflow?
  64. Add Category name to Post Title (h1)
  65. Blogroll – Different layout for first post
  66. How to delete old posts’ edits to save space?
  67. When trashing a post, also trash related comments
  68. Image Insert into posts and pages not working after 3.2.1 update
  69. allow new users to post an article before they sign up [closed]
  70. Make Post Editor Select Number of Columns To 1 By Default
  71. Adding the_date inside tags around the_content
  72. Mixing Tweets with Posts
  73. Problem with permalink routing?
  74. Making a custom Pagination for multi page blog post
  75. WordPress is replacing double minus signs in Post Title, how to disable it?
  76. using is_paged for hiding image on posts
  77. How to display the post categories for each post inside the loop with custom format?
  78. Allow / show post comments in category pages
  79. Filter post by users creation date
  80. Function is printing twice – any suggestions?
  81. Recent Post Issue
  82. how to create a category with wp_insert_post and post_category
  83. Extracting the permalink from a post instance
  84. How to add a block to a category page?
  85. 2 Domains, Same Content, Different Titles?
  86. Adding wordpress posts using phpmyadmin
  87. How can I get post text from all posts on a WordPress news site?
  88. Changing the Category for all posts of an Author
  89. Posting a comment redirects admin/users to blank page
  90. Is it possible to have dynamic post id # in add_menu_page()?
  91. Hiding menu on mobile only when viewing posts?
  92. Posts don’t appear on Template Page
  93. Latest Posts not in the right order
  94. Howto put advertising as post number 1,2,3 etc
  95. limit posts per page
  96. WordPress Admin Tables in Post View
  97. Print out one of 2 post category [closed]
  98. How to get if category has posts?
  99. How can I add a custom caclulation form in post?
  100. Restore posts, but only posts that exist in my database backup