加载数据本地文件php mysql [英] LOAD DATA LOCAL INFILE php mysql
本文介绍了加载数据本地文件php mysql的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我遇到错误
#7890 - Can't find file 'C:UsersAdminDesktopBL postcodes.csv.zip'.
这是脚本
LOAD DATA LOCAL INFILE 'C:\Users\Admin\Desktop\BL postcodes.csv.zip'
IGNORE INTO TABLE uk_pc
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(Postcode, Latitude, Longitude, Easting, Northing, GridRef, County, District, Ward, DistrictCode, WardCode, Country, CountyCode)
我试图更改文件夹并更改权限,但出现相同的错误...(在localhost服务器上工作)
i have tried to change folders and change permission also but same error ... (working on localhost server)
推荐答案
'C:UsersAdminDesktopBL postcodes.csv.zip'
路径必须是错误的,因为它不包含斜杠.尝试:INFILE 'C:\\Users\\Admin\\Desktop\\BL postcodes.csv.zip'
'C:UsersAdminDesktopBL postcodes.csv.zip'
path has to be wrong because it doesn't have traling slashes. try: INFILE 'C:\\Users\\Admin\\Desktop\\BL postcodes.csv.zip'
并尝试解压缩文件.
这篇关于加载数据本地文件php mysql的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文