What’s the database relationship between a post and its attachments

The post that an attachment is related to is determined by the post_parent column on the wp_posts table (depending on your database prefix). Set it to the post_ID of the parent post.

Related Posts:

  1. Export WP database for import using WP-CLI on Vagrant Box
  2. Importing CSV into database table not working?
  3. Featured image from custom to WordPress database
  4. Why is my database import losing text widget data?
  5. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  6. Best way to import users, post and categories from an external database
  7. How to create bulk page and content? [closed]
  8. Importing posts from old website to new conflicting post ID’s?
  9. remove missing image attachments
  10. When importing database, it shows error
  11. Upload files – total size limit – WordPress/Contact Form 7
  12. Get Database Credentials from within the themes file
  13. Is a direct or import approach safer for migration into WordPress?
  14. MySQL Syntax Error upon restoring database from backup [closed]
  15. Import live site to local setup without access to live site
  16. Error establishing a database connection; After importing DB & Theme
  17. WordPress database import: Row size too large
  18. Export / import WordPress database
  19. Bulk-create posts from SQL database
  20. Merging two databases without borking it
  21. Import users from old WP site to new one
  22. import posts with dutch/special letters
  23. Importing 10 Years of Media into the WP Database
  24. Connection refused on locahost after importing database?
  25. Importing Direct to DB – GUID Question
  26. Best practice to import user base (subscribers) from one website to another?
  27. Importer fails to import every post
  28. Location of image metadata on my server
  29. Add pdf to a website
  30. WordPress database products structure
  31. Is it good practice to import/export a blog to test a redesign?
  32. Realtime database update from 3rd party apps (notion, airtable, sheet, etc)
  33. How to fix Uploaded to this post option to see group of images uploaded to a post?
  34. Media Library doesn’t allow uploads? Upload Directory
  35. Media library images “missing” after migrating them using SQL
  36. import (migration) user database to wp-users
  37. I broke database after reuploading local version – what exactly happened? Database error
  38. Importing Concrete5 content to WordPress
  39. Uploaded images not displaying full size preview or inserting into posts
  40. Many images in wp-content/uploads folder that are not in Media Library
  41. Staging sites, how do you manage synchronising updates in the DB?
  42. How to get the post publish date outside the loop?
  43. Using transients in conjunction with memcached
  44. How to define composite keys with dbDelta()
  45. Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
  46. Forcing nickname as display_name in custom edit profile template
  47. Corrupt WordPress Database
  48. Can I attach a document (eg: PDF) but have a JPEG as a thumbnail?
  49. Updating all rows of table with $wpdb
  50. What actions affect files, DB, or both?
  51. Cannot unserialize WordPress serialized values in `wp_options` table?
  52. Is $wpdb->prepare escaping to much? How to use it properly?
  53. Using same database for main and subdomain
  54. What is stored in the webserver? (Separated Database)
  55. Remove database entries where post_date > expiration date
  56. Emojis getting converted to “?”
  57. Building a Scalable Resiliant WP Setup
  58. Single database for multiple instances
  59. Get all tags not just first 10 with wp api 2.0
  60. Search and replace special characters (å,ä,ö) for image attachments only in database
  61. Accidentally deleted active_plugins portion of the wp_options DB table
  62. delete post meta from db, even if does not exist?
  63. In what part of the WordPress core does the users table and usermeta table get joined?
  64. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  65. Output custom content not from the posts table?
  66. Iterating through $wpdb query without using get_results for large query results
  67. Reducing Database Query Time
  68. How can I get my wordpress password from an SQL file?
  69. Is there an atomic way to update_option in WordPress (to ensure data integrity)?
  70. All text disappeared (seems to be a database problem) [closed]
  71. is wordpress stores Role Id in WP database?
  72. Why do database examples sometimes finish with an add_option call?
  73. How to transform a custom made static HTML website to a WordPress website [closed]
  74. Upload media only to DB
  75. WordPress Creates Unused (Unregistered) Image Sizes
  76. How and where is wordpress adding mySQL content to database?
  77. How get Data form wordpress database as array not stdclass?
  78. cannot connect database
  79. How to delete a particular row in a database table
  80. Connecting to wordpress database in my application [closed]
  81. change the year on all of my custom post types?
  82. WordPress keeps redirecting to localhost
  83. get value from ‘terms’ table
  84. custom tables in wordpress Database? (can i just create them with sql?)
  85. Import a folder containing HTML files and images to WordPress
  86. Import media (.xml) does not attribute featured images to posts
  87. Displaying requested data from a the database in wordpress
  88. Accidently changed the GUID
  89. Restore Old Database Over Newer WP & Plugin Files
  90. Not sure what to do next to optimize
  91. Database structure for thousands of posts
  92. $wpdb not working
  93. Accessing content from third party as native posts in WordPress
  94. Extracted CSV as Array for Custom Query Loop
  95. Limit attachment caption characters
  96. One WP Database outside localhost and two connections
  97. Fetch data from another site, but the same database
  98. Every time I update or install a plugin I get “Error Establishing a Database Connection in WordPress”
  99. Upload wordpress from localhost to 000webhost
  100. Leveraging Core Functionality in Icon Upload Plugin [closed]

Leave a Comment