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
Post a Comment