mysql - #1064 - You have an error in your SQL syntax for coding a new database -


1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near ')' @ line 5

the code is:

create table click_count (      id int unsigned not null auto_increment primary key,      page_url varchar(255) not null,      page_count int unsigned not null, ); 

remove trailing comma before closing parenthesis:

create table click_count (     id int unsigned not null auto_increment primary key,     page_url varchar(255) not null,     page_count int unsigned not null ); 

Comments