equivalent MySQl to dateInsert SMALLDATETIME NULL DEFAULT getdate()

[anselme]

I am looking for the equivalent of MS SQL

dateInsert SMALLDATETIME NULL DEFAULT getdate()

for mySQl 5

i am trying

dateInsert DATETIME NULL DEFAULT NOW()

but it doesnt work

thank you for helping

[rmiao]

Did you read MySql manual?

[anselme]

the manual is very long to read, the forums are helpfull for a special problem

dateInsert TIMESTAMP

will update every time the row is changed, it is not what i want , i want to store the INSERT date once for each row