how do you make timestamp have a default value

[makeshift]

mysql manual says that timestamp updates everytime an INSERT or UPDATE query is done on the affected row.

When im initially adding the row and say i have a table that has two values "id" and "timestamp"... the first being an auto-inrement id and the second of TIMESTAMP(14) type.

when i do the query

"INSERT INTO faketable VALUES ('0',??)"

What do i put in for "??" to make it automatically match the current server time. I'll be making this query through PHP of course, so yea, how do i do it?

• Drew

[LordShryku]

now()

[makeshift]

thanks.

:]