mysql for excel(mysql for excel)
我不确定这是否是提出这个问题的正确位置,但我面临一个安装MySQL的问题,无法识别Office 2013并安装MySQL for Excel。
基本上是MySQL https://dev.mysql.com/downloads/
有一个excel插件,允许您自动连接到数据库并进行更改。 在MySQL安装期间,它会检查需求,其中一个是Excel 2007或更高版本。 这个要求对我来说并不符合。 我正在运行Office 2013 Pro Plus(64位)和安装MySQL(64位)
有人可以帮忙吗? 你推荐其他任何应用程序吗? 我不想手动导入和导出数据或文件。 我需要一个应用程序,在单独的工作表中打开所有表,我可以手动更改并自动保存到数据库。
任何建议表示赞赏
I am not sure if this is the right place to ask this question but I am facing an issue with MySQL installed failing to recognize office 2013 and install MySQL for Excel.
Basically MySQL https://dev.mysql.com/downloads/
Has an addin for excel that allows you to automatically connect to a database and make changes. During the MySQL installation it checks for requirements, one of which is Excel 2007 or greater. And that requirement is not met for me. I am running Office 2013 Pro Plus (64bit) and Installing MySQL (64bit)
Can someone help? Is there any other application that you recommend? I dont want to import and export data or files manually. I need an application that opens all the tables in separate sheets that I can manually change and automatically save to the DB.
Any advice appreciated.
原文:https://stackoverflow.com/questions/14763141
满意答案
INSERT查询中存在语法错误
INSERT INTO acc2 SELECT t.id, r.'parent_id' /*--COMMENT : remove '' from 'parent_id' , it should be r.parent_id */ FROM test AS t JOIN acc2 AS r ON t.parent_id = r.id;
You have syntax error in INSERT query
INSERT INTO acc2 SELECT t.id, r.'parent_id' /*--COMMENT : remove '' from 'parent_id' , it should be r.parent_id */ FROM test AS t JOIN acc2 AS r ON t.parent_id = r.id;
相关问答
更多替代临时表(alternative to temporary tables)
如何将SQL查询的输出插入临时表中?(How to insert the output of a SQL Query into a temporary table?)
PostgreSQL临时表(PostgreSQL temporary tables)
使用存储过程将数据插入两个临时表(Insert data into two temporary tables using a stored procedure)
TEMPORARY表在Mysql中(TEMPORARY table in Mysql)
从临时表插入(Inserting from a temporary table)
Hierachy,临时表插入(Hierachy, Temporary Tables Insert from)
MySQL临时表不清楚(MySQL temporary tables do not clear)
从两个临时表中插入表(INSERT INTO Table From Two Temporary Tables)
从sp_executsql INSERT INTO临时表(INSERT INTO temporary table from sp_executsql)
相关文章
更多关于excel文件导入到mysql数据没有读取到文件问题
mysql问题
这种的EXCEL表格 怎么来解析??
JXLS根据excel模板生成EXCEL并下载
POI 操作 Excel的主要API
POI读取数据库数据到excel
使用POI操作Excel和Word
用HQL语句导出excel(1500行*100列)速度逐渐变慢
POI 操作Excel公式
关于netbeans和mysql的问题
最新问答
更多获取MVC 4使用的DisplayMode后缀(Get the DisplayMode Suffix being used by MVC 4)
如何通过引用返回对象?(How is returning an object by reference possible?)
矩阵如何存储在内存中?(How are matrices stored in memory?)
每个请求的Java新会话?(Java New Session For Each Request?)
css:浮动div中重叠的标题h1(css: overlapping headlines h1 in floated divs)
无论图像如何,Caffe预测同一类(Caffe predicts same class regardless of image)
xcode语法颜色编码解释?(xcode syntax color coding explained?)
在Access 2010 Runtime中使用Office 2000校对工具(Use Office 2000 proofing tools in Access 2010 Runtime)
从单独的Web主机将图像传输到服务器上(Getting images onto server from separate web host)
从旧版本复制文件并保留它们(旧/新版本)(Copy a file from old revision and keep both of them (old / new revision))
Copyright ©2023 peixunduo.com All Rights Reserved.粤ICP备14003112号
本站部分内容来源于互联网,仅供学习和参考使用,请莫用于商业用途。如有侵犯你的版权,请联系我们(neng862121861#163.com),本站将尽快处理。谢谢合作!