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