1

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: MySQL: How to create trigger for setting creation date for new rows

Improve this question
1
  • Conclusion: 1. TIMESTAMP column with default value CURRENT_TIMESTAMP can be only one. 2. If you're want to auto insert date on create row action you may use: ALTER TABLE jv-temp.store_order MODIFY creation_date TIMESTAMP NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP; Commented Aug 3, 2010 at 11:00

2 Answers 2

Reset to default
3

Use TIMESTAMP DEFAULT CURRENT_TIMESTAMP field

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

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

Take care with this, as the timestamp column will get set on an UPDATE. Your updates will have to specify TIMESTAMP_COLUMN = TIMESTAMP_COLUMN as one of the things SET, otherwise the creation date will be lost.
Only if it will have ON UPDATE CURRENT_TIMESTAMP in CREATE TABLE definition.
It does't work. On CREATE do work, but on UPDATE it set to NULL.
1

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.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.