On 3/2/06, rtroiana <[EMAIL PROTECTED]> wrote: > Thanks to all of you for replying. I'm using DATETIME instead of TIMESTAMP > now. Although I still haven't find the answer for my second question. > > > > > > I used to use > > > "CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP" as default value for my > > > TimeStamp column. Is there a way to assign default value to a DateTime > > > column, since I couldn't find that in the documentation? >
Sure. You could run a trigger on an insert statement to update the DATETIME field to the contents of SELECT NOW(); -Sheeri -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
