mysql - ERROR 1064 (42000) when running .sql script -


i using mysql 5.5.31

the script trying run is:

drop table if exists trv_acct /  create table trv_acct (   acct_num varchar(10) not null,   acct_name varchar(50),   acct_type varchar(100),   acct_fo_id decimal(14,0),   obj_id varchar(36),   ver_nbr decimal(8,0) default 0,   sub_acct varchar(10),   sub_acct_name varchar(50),   create_dt datetime,   subsidized_pct float,   primary key (acct_num) ) engine=innodb default charset=utf8 collate=utf8_bin 

and error info is:

mysql> \. create_travel_tables.sql error 1064 (42000): have error in sql syntax; check manual corresponds mysql server version right syntax use near '/  create table trv_acct (   acct_num varchar(10) not null,   acct_name varchar(' @ line 2 

any appreciated, thanks.

the error stated in error message:

you have / in second row, not belong there!


Comments

Popular posts from this blog

c# - Operator '==' incompatible with operand types 'Guid' and 'Guid' using DynamicExpression.ParseLambda<T, bool> -