Defaulting Date Field

[Jesse]

What is the best way to default a date/time field to the current date/time? 
I've tried using Now(), but I get an error of course.  The only other way I 
know of to do this is to add a trigger, which I can do, but I find them 
bothersome, because they don't tend to backup and restore properly.  Is 
there another way to do this?

Thanks,
Jesse 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]