Saturday, 15 August 2015

ERROR TO CREATE TABLE IN MYSQL -



ERROR TO CREATE TABLE IN MYSQL -

i'm trying create table in sql,

create table `online_status` ( `fk_user_id` int(10) unsigned not null default '0', `last_activity` timestamp(14) not null, primary key (`fk_user_id`) ) engine=myisam;

but returning error.

1064 - have error in sql syntax; check manual corresponds mysql server version right syntax utilize near '(14) not null, primary key (fk_user_id) ) engine=myisam' @ line 3

i've changed commas, error continues. can help me on wrong?

`last_activity` timestamp(14) not null,

should be

`last_activity` timestamp not null,

mysql

No comments:

Post a Comment