将excel文件导入mysql数据库时出现问题 [英] problem in importing a excel file into mysql database

问题描述

我已成功将excel/csv文件导入数据库，但是存在问题..
我只需要将该CSV文件保存在localhost \ mysql \ data \ prfolder中.否则，如果我要导入计算机中任何位置的文件，就会出现错误，我该怎么办....
如果您理解我的问题，请帮助我....

i have successfully imported excel/csv file to the database but there s problem..
I have to saved that csv file in only localhost\mysql\data\prfolder. otherwise it gives an error what i have to do if i want to import that file which is anywhere in computer....
If you understand my question please help me....

推荐答案

不要使用localhost，它是通过Internet(http或ftp)请求的.使用本地主机目录代替本地主机，例如"C:\ Program Files \ Apache Software Foundation \ Apache2.2 \ htdocs \ mysql \ data \ prfolder"或"C:\ www \ mysql \ data \ prfolder"或您的数据目录在哪里

Don''t use localhost, it is to request via internet(http or ftp). Use your localhost Directory instead of Localhost for Example ''C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\mysql\data\prfolder'' or ''C:\www\mysql\data\prfolder'' or where is your data Directory

这篇关于将excel文件导入mysql数据库时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！