An SQL injection vulnerability occurs when you use a variable in your SQL statement and someone uses the variable to add unexpected code. In this article, we’ll look at how this occurs and how to prevent it.
By default all of the WordPress database tables will start with the prefix “wp_” (e.g. wp_users, wp_posts, etc.). Because this is the default value, you’ll often hear the tables referred to (and written about) using the “wp_” prefix. Let’s look at how and why this prefix is modified.
A list of the database tables (and the columns in those tables) used by a default WordPress installation. This is the companion blog post to my talk, “Introduction to the WordPress Database”.
In the WordPress database table “wp_term_taxonomy”, each row almost always has the same value for the two columns ‘term_taxonomy_id’ and ‘term_id’. What is the difference between these two columns?