[EMAIL PROTECTED]>,
>[EMAIL PROTECTED]
>Subject: Re: Default created date field
>Date: Mon, 15 Jul 2002 17:56:18 +0200
>
>On Monday, 15. July 2002 16:51, Shawn Poulson wrote:
>
>Hi,
>
> > I'm having trouble doing this in MySQL, but it keeps co
On Monday, 15. July 2002 16:51, Shawn Poulson wrote:
Hi,
> I'm having trouble doing this in MySQL, but it keeps complaining. All I
> have to work on is:
> create table mytable (
>createddate datetime not null default now()
> )
>
Just use timestamp instead datetime.
Regards
Georg
mysql,q
Shawn,
Monday, July 15, 2002, 5:51:01 PM, you wrote:
SP> I'm new to this list and MySQL, so I hope this question isn't too
SP> rudimentary.
SP> In SQL Server I was able to create a datetime field that used the default
SP> getdate() function so that I woudl get timestamps on all created rows
S
Hello all,
I'm new to this list and MySQL, so I hope this question isn't too
rudimentary.
In SQL Server I was able to create a datetime field that used the default
getdate() function so that I woudl get timestamps on all created rows
automatically, like:
create table mytable (
createddate