[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes:
> now,what statement do I use to put the sysdate into the column today?
> this is NOT working
> insert into datee values(select DAYOFMONTH(sysdate()));
Of course not. "insert into datee values (Now())" will, though. Just feed it
to mysql ... ;)
Here
TED]
> Temat: sysdate() query and note to Mysql admin
>
>
>
> Hi,
> I my name is ryan and I own a small site which has a mysql
> database and servlet support.
>
> I have a simple query to all you mysql gurus...
> my table is very simple, i created a table with the foll
Hi,
I my name is ryan and I own a small site which has a mysql database and servlet
support.
I have a simple query to all you mysql gurus...
my table is very simple, i created a table with the following
create table datee(int today);
now,what statement do I use to put the sysdate into the colu
