Wow this is fantastic! Thank you. Will bookmark this for reference. I understand what a lot of this does but some wasn't so sure on, this will help me bone up on what's what in WordPress :)

Such a great post... I definitely don't love playing around in the database, but it's certainly necessary at times. This is clear and easy to follow. Thanks!

Impressive... in the fact that I was able to comprehend this in such a quick read! Nice job Iain, much appreciated! Stuff I've known existed for years but didn't take the time to digest properly.

Really great Post - will be sure to add to my toolbox.

Thanks iain. I've always wondered what term_group is for. Interesting that it's unused. Do you have any idea what it was originally intended for?

Good one! Bookmarked for my students.

This is super helpful; thanks a lot.

This is such an epic resource. Bookmarked. Thanks for sharing.

Iain, a couple of corrections. You should mention that core WordPress doesn't use post_content_filtered in the wp_posts table, but some plugins do. Also the term_group column in the wp_terms tables is used by WordPress core. If a plugin or theme populates it (that is, sets up synonym terms), WordPress will handle it correctly. Lastly, your "meta" references to "this post" meaning this blog post will be utterly confusing to some people, especially given that you acknowledge the confusion around the term anyway. It would help to clarify them.

Thank you. Very easy to understand.

Thanks a lot for filling in the WP codex gaps!

"Here at Delicious Brains we eat, drink and sleep databases." But I thought you eat ...brains. : )

Thank you, thank you, thank you!

Is a place to see the image with tables always upgraded to last wp version? and is there simple way (visual way i'd like) to control which table an installation plugin adds?

"guid – Global Unique Identifier, the permanent URL to the post, not the permalink version." -- not exactly true. The permalink at creation time is used solely because it's a handy unique ID, but you can use any GUID-generating algorithm to create a GUID for a post. It's something that should not change (even when migrating data, except in the circumstances that Brad outlines) and can be used to differentiate two posts from each other (e.g. in RSS feeds, or safely and repeatably merging content from multiple sources)

Great post! However, your explanation of wp_term_taxonomy may be out of date as of WP 4.1 as shared terms are no longer created.

very useful.....

thankyou so much.. i need this for my task.. very useful

Thank you, excellent article.

osm article..thank you

thanks man it's very help full for beginner

Any chance you guys will update this article with the additions to the new tables added since it was posted? ie, specifically wp_termmeta?

Hi every one. Is it possible to hash or encrypt some informations inside wordpress database like : user_login user_nicename user_email post_password Thanks in advance for your answer

why wordpress added postMeta table if we can add any number of columns in post table through sql queries?

any writup on the woocommerce database

very interesting article, but how it be posted in 3 of June 2020, and so many comments to be from 5 years agor???

How do we change the CHARSET?