creating a table

[Abyss Abyss]

Hi all

im not a newbie as such, i just dont know mysql that well enough to find an answer to this question..
When i create a table i wish to have a column named registrationdate
and for it to be datetime, but i want the default to be the time that the recordset is created..does that make sense?


" RegistrationDate DATETIME DEFAULT 0, " & _

Thanks heaps...

ps is there anywhere i can make a suggestion about mysql query browser?

because it is frustrating having to type the datatypes in, and not having a drop down box to select them from

Thanks heaps..

Abyss
www.abyss.ws