can't create this table with datetime column, why?

[Phil Powell]

I am unable to determine which version of mySQL is running on a remote
server (and the client doesn't know either, and I can't reach the host.. oh
what I'll do for $80)...

create table if not exists fs_usermetadata (
fs_userid int not null,
primary key(fs_userid),
fs_username varchar(255) not null,
fs_password varchar(255) not null,
fs_user_categor y_id int not null,
fs_user_firstna me varchar(255),
fs_user_lastnam e varchar(255),
fs_user_address 1 varchar(255),
fs_user_address 2 varchar(50),
fs_user_city varchar(255),
fs_user_state_p rovince varchar(3),
fs_user_zip_pos tal varchar(20),
fs_user_country varchar(3),
fs_user_homepho ne varchar(50),
fs_user_workpho ne varchar(50),
fs_user_fax varchar(50),
fs_user_isHome varchar(1) not null,
fs_user_ip varchar(15),
fs_record_enter ed datetime default NOW(),
fs_payment_meth od varchar(10) not null
);

Can any of you determine why the fs_record_enter ed column call continually
produces a SQL error? I am trying to set it to default to now() and it fails
every time. Augh!

Thanx
Phil

[Patrick Cronin]

Phil Powell wrote:

I am unable to determine which version of mySQL is running on a remote
server (and the client doesn't know either, and I can't reach the host..
oh what I'll do for $80)...

create table if not exists fs_usermetadata (
fs_userid int not null,
primary key(fs_userid),
fs_username varchar(255) not null,
fs_password varchar(255) not null,
fs_user_categor y_id int not null,
fs_user_firstna me varchar(255),
fs_user_lastnam e varchar(255),
fs_user_address 1 varchar(255),
fs_user_address 2 varchar(50),
fs_user_city varchar(255),
fs_user_state_p rovince varchar(3),
fs_user_zip_pos tal varchar(20),
fs_user_country varchar(3),
fs_user_homepho ne varchar(50),
fs_user_workpho ne varchar(50),
fs_user_fax varchar(50),
fs_user_isHome varchar(1) not null,
fs_user_ip varchar(15),
fs_record_enter ed datetime default NOW(),
fs_payment_meth od varchar(10) not null
);

Can any of you determine why the fs_record_enter ed column call continually
produces a SQL error? I am trying to set it to default to now() and it
fails every time. Augh!

Thanx
Phil

From the MySQL Online Manual(http://www.mysql.com/doc/en/CREATE_TABLE.html)
"Default values must be constants. This means, for example, that you cannot
set the default for a date column to be the value of a function such as
NOW() or CURRENT_DATE."

--
--PC
"Of course, that's just my opnion. I might be wrong"

[Patrick Cronin]

Phil Powell wrote:

I am unable to determine which version of mySQL is running on a remote
server (and the client doesn't know either, and I can't reach the host..
oh what I'll do for $80)...

create table if not exists fs_usermetadata (
fs_userid int not null,
primary key(fs_userid),
fs_username varchar(255) not null,
fs_password varchar(255) not null,
fs_user_categor y_id int not null,
fs_user_firstna me varchar(255),
fs_user_lastnam e varchar(255),
fs_user_address 1 varchar(255),
fs_user_address 2 varchar(50),
fs_user_city varchar(255),
fs_user_state_p rovince varchar(3),
fs_user_zip_pos tal varchar(20),
fs_user_country varchar(3),
fs_user_homepho ne varchar(50),
fs_user_workpho ne varchar(50),
fs_user_fax varchar(50),
fs_user_isHome varchar(1) not null,
fs_user_ip varchar(15),
fs_record_enter ed datetime default NOW(),
fs_payment_meth od varchar(10) not null
);

Can any of you determine why the fs_record_enter ed column call continually
produces a SQL error? I am trying to set it to default to now() and it
fails every time. Augh!

Thanx
Phil

From the MySQL Online Manual(http://www.mysql.com/doc/en/CREATE_TABLE.html)
"Default values must be constants. This means, for example, that you cannot
set the default for a date column to be the value of a function such as
NOW() or CURRENT_DATE."

--
--PC
"Of course, that's just my opnion. I might be wrong"

[Patrick Cronin]

Phil Powell wrote:

I am unable to determine which version of mySQL is running on a remote
server (and the client doesn't know either, and I can't reach the host..
oh what I'll do for $80)...

create table if not exists fs_usermetadata (
fs_userid int not null,
primary key(fs_userid),
fs_username varchar(255) not null,
fs_password varchar(255) not null,
fs_user_categor y_id int not null,
fs_user_firstna me varchar(255),
fs_user_lastnam e varchar(255),
fs_user_address 1 varchar(255),
fs_user_address 2 varchar(50),
fs_user_city varchar(255),
fs_user_state_p rovince varchar(3),
fs_user_zip_pos tal varchar(20),
fs_user_country varchar(3),
fs_user_homepho ne varchar(50),
fs_user_workpho ne varchar(50),
fs_user_fax varchar(50),
fs_user_isHome varchar(1) not null,
fs_user_ip varchar(15),
fs_record_enter ed datetime default NOW(),
fs_payment_meth od varchar(10) not null
);

Can any of you determine why the fs_record_enter ed column call continually
produces a SQL error? I am trying to set it to default to now() and it
fails every time. Augh!

Thanx
Phil

From the MySQL Online Manual(http://www.mysql.com/doc/en/CREATE_TABLE.html)
"Default values must be constants. This means, for example, that you cannot
set the default for a date column to be the value of a function such as
NOW() or CURRENT_DATE."

--
--PC
"Of course, that's just my opnion. I might be wrong"