mysql - Syntax error in create table query -

mysql - Syntax error in create table query -

i cant syntax error.

#1064 - have error in sql syntax; check manual corresponds mysql server version right syntax utilize near '(id) engine=myisam)' @ line 15

create table if not exists `destination_cdr` ( `id` bigint( 20 ) not null auto_increment , `calldate` datetime not null , `source` varchar( 80 ) not null , `destination` varchar( 80 ) not null , `account_code` varchar( 30 ) default null , `pincode` varchar( 45 ) not null , `duration_call` bigint( 20 ) not null default '0', `duration_talk` bigint( 20 ) not null , `disposition` varchar( 255 ) not null , `clid` varchar( 80 ) default null , `cdr_id` bigint( 20 ) default null , `vxcdr_id` bigint( 20 ) default null , `provider` int( 11 ) not null default '0' primary key ( `id` )) engine = myisam ;

you need commma between provider , primary key:

`provider` int( 11 ) not null default '0', primary key ( `id` )) engine = myisam

mysql sql phpmyadmin syntax-error