将CSV或XML导入MySQL [英] Import CSV or XML to MySQL
问题描述
我有两个巨大的数据库格式CSV&
I have two huge databases in both formats CSV & XML, and I want to import to MySQL the databases.
我试图使用:LOAD DATA INFILE,但我收到此错误消息:
ERROR 1064 42000):您的SQL语法中有错误;请检查与您的MySQL服务器版本对应的手册,以获取在第1行附近使用的正确语法
I tried to used : LOAD DATA INFILE, but I receive this error message : 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 '' at line 1
MySQL版本:5.1.56-log
MySQL Version : 5.1.56-log
我没有成功使用PHP将XML转换为数组,然后逐行插入。
I tried without any success to use PHP to convert XML to array then Insert line by line.
编辑:
我使用这个查询作为root来导入XML到MySQL:
I used this query as root to import XML to MySQL :
LOAD XML LOCAL FILE'/ home / floupie / public_html / All.xml'INTO TABLE k_logs
;
LOAD XML LOCAL FILE '/home/floupie/public_html/All.xml' INTO TABLE k_logs
;
推荐答案
csv加载的语法。
LOAD DATA LOCAL INFILE '/importfile.csv'
INTO TABLE test_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(field1, filed2, field3);
这是xml加载的适当语法。
This is the appropriate syntax for an xml load.
LOAD XML LOCAL INFILE 'items.xml'
INTO TABLE item
ROWS IDENTIFIED BY '<item>';
这篇关于将CSV或XML导入MySQL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!