本文介绍了MySQL的批量插入一个文本文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有纯文本文件,我想通过行该文本文件的内容移动到MySQL表行任何一个可以帮助我,因为它不是一个CSV文件我如何才能做到这一点。
我设计我的数据库如下:
的RowID,INT(11),NO,PRI,AUTO_INCREMENT文字,VARCHAR(94)//这里我插逐行记录类型,VARCHAR(50)内容样品
123456789007545654665654654634453453454353453478677564565465464684565464564565469078565656546546546456456456解决方案
试试这个
LOAD DATA LOCAL INFILEC:/ Documents和设置/管理/桌面/ Merge.txtINTO TABLE tblachmasterFIELDS TERMINATED BY','ENCLOSED BY''TERMINATED BY'\\ r \\ n'行忽略1线;I am having plain text file and i would like to move the content of that text file in to mysql table line by line can any one help me as it is not a csv file how can i achieve this
I designed my db as follows
RowID, int(11), NO, PRI,auto_increment Text, varchar(94) // Here i have to insert line by line RecordType, varchar(50)Content sample
123456789007 545654665654654 6344534534543534534 786775645654654646 8456546456456546 9078565656546546546456456456解决方案
Try this
LOAD DATA local INFILE 'C:/Documents and Settings/Administrator/Desktop/Merge.txt' INTO TABLE tblachmaster FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES;
更多推荐
MySQL的批量插入一个文本文件
发布评论