yowkee essential

entry_category_id in mt_entry

For the first time, I took a look at MT tables and play around. Then I found the field entry_category_id in table mt_entry contains all NULL value. Shouldn’t it be the category id of the entry? It sounds obvious to get an entry’s category in mt_entry table.

Later, by reading Brad’s SQL statement for Mark’s nothing personal RSS feed, I realized the category id is actually stored at mt_placement. And apparently, it’s for the purpose of able to link one entry to multiple categories. But where could I put the multiple categories to one entry? The option isn’t at new entry or power-editing mode of editing entries.…

[update] I am so careless. There is a little mark “Assign Multiple Categories” sit right beside the Primary Category.