Сreate trigger in MySQL or not (via PHP)?

Question

Table in MySQL have 1 problem column: creation_date.

During inserting a new row through PHP, I thought that there would be correct to insert the date directly in the query, MySQL has to do it himself.

Do I need to do the trigger, or it would be better to use PHP for this, as intended? How would you have done to?

PS: http://stackoverflow.com/questions/2906978/mysql-how-to-create-trigger-for-setting-creation-date-for-new-rows

Answer 1

Use TIMESTAMP DEFAULT CURRENT_TIMESTAMP field

http://dev.mysql.com/doc/refman/5.0/en/timestamp.html

Answer 2

If you create a trigger for your table (or adopt the suggestion above) you won't have to remember to do it in your PHP. This advantage will show when someone else creates another PHP to insert into the same table.