drop table if exists xmlfile;
CREATE TEMPORARY TABLE xmlfile (
txtline TEXT NOT NULL,
FULLTEXT (txtline)
) ENGINE = MyISAM;-- LOAD DATA INFILE '..//..//a.xml'INTO TABLE xmlfile;
set @xmlPath = CONCAT( "\'", SUBSTRING_INDEX(@@global.basedir, '\\', 4),'\\a.xml',"\'");
LOAD DATA INFILE @xmlPath INTO TABLE xmlfile;
传入变量@xmlPath之后有语法错误,请帮忙分析一下为什么哩? ERROR 1064 (42000): 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 '@xmlPath INTO TABLE xmlfile' at line 1语法
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货