No functions as default values is a bummer, but timestamp will do he trick, so thanks for your help; much appreciated.
Phil. -----Original Message----- From: Cybot [mailto:[EMAIL PROTECTED] Sent: 06 August 2003 15:37 To: [EMAIL PROTECTED] Subject: Re: Functions as default values > I am trying to use a function as a default value for a column but do not > seem to get the desired result. I want to use the NOW() function for a > last_updated column, here is my code... > > CREATE TABLE test_table ( > last_updated datetime NOT NULL default `NOW()` > ) TYPE=MyISAM; > > This gives an error; > > CREATE TABLE test_table ( > last_updated datetime NOT NULL default 'NOW()' > ) TYPE=MyISAM; > > Now the table shows a default value of 0000-00-00 00:00:00, when I add a new > row the value of last_updated is also 0000-00-00 00:00:00. I am using MySQL > 3.23.37, can anyone help? funcion as default-value is not allowed AFAIK but timestamp will help you to get what you want! http://www.mysql.com/doc/en/DATETIME.html -- Sebastian Mendel www.sebastianmendel.de www.tekkno4u.de www.nofetish.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]