Have you ever opened up your database? Have you poked around in there to understand the layout and different buckets of content and information? In today’s quick tip, you’ll look at the
wp_posts database table. You’ll learn about basic database terminologies, such as record, row, primary key, and columns. You’ll see how the columns within a record relate to the content you see in the WordPress back-end.
Go ahead. Open up phpMyAdmin or Sequel Pro in your sandbox site. Let’s play with it and open your eyes up to how/where WordPress stores the content.
Dynamic content requires a storage system to retain the content, settings, and information. WordPress uses MySQL as its relational database. In this hands-on lab, you will dig into the WordPress database structure, do basic raw SQL queries, and learn about the relationship between WordPress and its database.
Check out the SQL Library for more hands-on labs, insights, Docx, and more.