[SOLVED] DATETIME and NOW()

[xProteuSx]

When I create a table in MySQL, how do I go about creating a date/time value, that is updated when 'x' event occurrs.  Initially, I want the value to show the date/time value given by the now() function:

 

CREATE TABLE whatever

(lastvisit DATETIME 'now()')

 

????

[bibby]

 

# depending on your version

create table blah (lastvisit datetime default current_timestamp);

[fenway]

Trust me, you don't want this... handle it yourself.