Why does WordPress prefix its column names with the table name?

3 Views

I noticed that in a recent update WordPress decided to change all of its column names to include the table name prefix. WHY?!

The wp_posts table now has a column called post_title, for example. It used to just be title. I don’t understand the reason for this change. There must’ve been one, yes?

Read More

I just don’t understand what possible reason there could be since in SQL you can refer to things like table.column. Also, it must’ve been really difficult to change all of the code.

Post Views: 3

Related posts

Leave a Reply

2 comments

  2. There is no good reason for doing this, plus it makes maintenance much more difficult.

    There is no confusion if columns are specified like:

    SELECT p.title, s.title FROM wp_posts p JOIN site s ON (p.site_id = s.id);