List:General Discussion« Previous MessageNext Message »
From:Marc Date:December 30 2005 3:11am
Subject:How to insert CURDATE() as default
View as plain text  
I forgot to mention - I'm running MySQL 4.0.14 on Linux. And I'm not very knowledgeable on
databases. I just use MySQL with Knoda to get the job done.

==========================
I've got a MySQL table that I'd like to have the current date,
CURDATE(), as the default in a column. I'm using knoda to worj with this
table. How do I use knoda to get this done? I can enter CURDATE() in the
default using the GridColumns button, but all that does is insert the
phrase "CURDATE()". I've got the column with "Date" for the ColummnType.

Thanks.


-- 
Marc <takeahike@stripped>

Thread
How to insert CURDATE() as defaultMarc30 Dec
  • Re: How to insert CURDATE() as defaultDanny Stolle30 Dec
    • Re: How to insert CURDATE() as defaultMarc30 Dec