mysql - SQL command line error -


i trying add table database in mysql using command line:

mysql -u jon -p testdb --password=password < "c:\users\jon\documents\summer\do\sql\root.sql" 

however, error when type above:

error 1064 (42000) @ line 12: have error in sql syntax; check manual corresponds mysql server version right syntax use near 'varchar(255) default null, clearing varchar(255) default null, globex varch' @ line 2 

i used dbforge create sql file called root.sql:

set names 'utf8';  use testdb;  drop table if exists roottable; create table roottable    (     productname varchar(255) default null,     clearing varchar(255) default null,     globex varchar(255) default null,     isactive varchar(255) default null,     floorid varchar(255) default null,     groupid varchar(255) default null,     subgroup varchar(255) default null,     conversionfactor varchar(255) default null,     id int primary key auto_increment   ) engine = innodb character set utf8 collate utf8_general_ci; 

this may funny, try save sql file utf8, open notepad.exe, save , choose utf-8 run query. have try.


Comments