从excel导入数据到mysql [英] import data into mysql from excel
问题描述
我正在尝试从excel将数据导入mysql数据库。
i已经为excel 1.2安装了mysql
i在mysql workbench中输入以下命令nd得到以下内容: br />
加载数据infile'D:\\\ xxxx'进入表格试用期;
输出:
错误代码:1045。访问被拒绝用户'gargi'@'localhost'(使用密码:是)0.000秒
当我在命令客户端输入相同时以下内容:
mysql>将数据加载'D:\\Book1.xlsx'加入表格书;
输出:
ERROR 1366(HY000):不正确的整数值:'PK♥♦ ¶'第1行第'栏'年龄'
pl帮助我这个或建议一些其他方法将数据导入mysql其他比phpmyadmin
i am trying to import data into mysql database from excel.
i have installed mysql for excel 1.2
i typed the following command in mysql workbench nd got the following:
load data infile 'D:\\b.xlsx' into table trial;
output:
Error Code: 1045. Access denied for user 'gargi'@'localhost' (using password: YES) 0.000 sec
when i typed the same in command client got the following:
mysql> load data infile 'D:\\Book1.xlsx' into table book;
ouput:
ERROR 1366 (HY000): Incorrect integer value: 'PK♥♦¶' for column 'age' at row 1
pl help me with this or suggest some other means to import data into mysql other than phpmyadmin
推荐答案
检查这种方法
如何到进口-AN-Excel的文件中对一个MySQL的数据库 [ ^ ]
让我知道它的工作与否..
Check this approach
how-to-import-an-excel-file-in-to-a-mysql-database[^]
let me know it's working or not..
这篇关于从excel导入数据到mysql的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!