I tried before writing you and wasn't able to. Maybe someone else can figure
out how but it looks like default will only take a constant as a parameter.
Cal
http://www.calevans.com
-----Original Message-----
From: Michael Blood [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 25, 2001 11:48 PM
To: Cal Evans; MYSQL
Subject: RE: Default Date value
Is it possible to set a function as a default value for a column at all.
I apologize if I come off a bit dumb about this but I come from an MSSQL
background where you can set a default to a function.
Thanks Again
-----Original Message-----
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 25, 2001 4:06 PM
To: Michael Blood; MYSQL
Subject: RE: Default Date value
BlankI don't think you can do that with a default value. You will need to
include the current date in your insert statement.
Cal
http://www.calevans.com
-----Original Message-----
From: Michael Blood [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 25, 2001 5:30 PM
To: MYSQL
Subject: Default Date value
I am trying to set the default value in a date field to be the time that
it was created
However I do not want the field to be a timestamp because I want to update
it to a different value later.
I have looked through the mysql documentation and I can not seem to find
anywhere that explains how to set the default value of a column = to a
function.
Anyone have any help?
Thanks in advance
Michael Blood
Matraex Technologies
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
