我试图使用命令行将表添加到
MySQL中的数据库:
mysql -u Jon -p testdb --password=password < "C:\Users\Jon\Documents\Summer\Do\SQL\root.sql"
但是,当我键入以上内容时出现错误:
ERROR 1064 (42000) at line 12: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VARCHAR(255) DEFAULT NULL, Clearing VARCHAR(255) DEFAULT NULL, Globex VARCH' at line 2
我使用dbForge创建一个名为root.sql的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;