添加产品到数据库时添加日期/时间

Question

I have tried to Google this so I didn't have to ask, as i'm sure this is a simple task...

I am building an E-commerce site and would like to add the date and time a product is added into the product database?

Apologies if this is simple, but i have researched everywhere else first.

Thanks

Answer 1

This can just be part of your database architecture:

ALTER TABLE  `products` ADD  `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

This will automatically add a timestamp to the column created whenever a row is created. For more information, try this: Automatic Initialization and Updating for TIMESTAMP

Obviously, in this case the table is called products and you would need to change it to whatever your table name is.

UPDATE To update all existing records at the same time, just run:

UPDATE `products` SET `created` = NOW()

If you want to be more specific use:

UPDATE `products` SET `created` = NOW() WHERE `created` = '0000-00-00 00:00:00'