您好,我在执行以下查询时遇到以下错误,我同时执行两个查询:CREATE TABLE IF NOT EXISTS Some_Data (Event_index INT, Record_index INT, Device_index SMALLINT, Phone_ID SMALLINT, Transaction_ID SMALLINT, Probe_Seq_Count SMALLINT, Probe_Seq_Result TEXT(100), Duration_Slots INT, Probe_PN SMALLINT, Probe_Sector INT, Probe_Color_Code SMALLINT, Sum_Probe_Count INT) ENGINE = INNODB;
LOAD DATA LOCAL INFILE '/home/path/data.csv' INTO TABLE Some_Data FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\\n';"ERROR: Query upload Error: (2014, "Commands out of sync; you can't run this command now")
这是我使用的代码,请帮助:
^{pr2}$
具有以下权限的用户:GRANT CREATE, DROP, INSERT, SELECT, UPDATE, DELETE, LOCK TABLES ON access.* TO 'some_user'@'localhost';
GRANT FILE ON *.* TO 'some_user'@'localhost';
FLUSH PRIVILEGES;
谢谢你!在