Thanks, Danny. This "little info" was all I needed. It works perfectly
now.
Have a Happy New Year!
--Marc
On Fri, 2005-12-30 at 10:28 +0100, Danny Stolle wrote:
> Marc,
>
> In MySql (I am using 4.1.9 and 4.1.15; so i am not sure about 5) it is
> not possible to use functions as default values
Marc,
In MySql (I am using 4.1.9 and 4.1.15; so i am not sure about 5) it is
not possible to use functions as default values; you could create:
create table tester (f_date date default curdate()); But this doesn;t
work. You have to struggle through your knoda how to present the current
date. B
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 t
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()".