mysql php 时间戳,PHP mysql自动插入时间戳

Say I have a table name auto_parts with these fields.

id, part, price, timestamp

and I insert a new row via php as so:

$query = "insert into auto_parts(id, part, price, timestamp)

values(1, 'axle', 200)"

mysql_query($query);

will that automatically add the timestamp.

Or do I have to insert a value for timestamp myself?

解决方案

What you need to do is declare timestamp to be of type in your sql

timestamp TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP

and modify the query to

$query = "insert into auto_parts(id, part, price)

values(1, 'axle', 200)"

mysql_query($query);