dbvis MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at lin
来源:互联网 发布:java微信系统源码 编辑:程序博客网 时间:2024/05/21 01:54
今天使用数据库查询工具DBvis链接mysql数据库时, 发现执行如何sql语句, 都报如下错误:
后来想着应该是mysql驱动包的版本不对导致的, 如何你和我一样, 也是这个问题困扰,那么现在就知道怎么回事了。
我的版本如下:
解决办法:
去mysql官网下载最新的jar驱动包 然后更新就行.
url:http://dev.mysql.com/downloads/connector/j/
选择平台,下载(mysql-connector-java-5.1.33.tar.gz)
最后更新到dbvis jar包到相应的目录下就行,删除原来的,重启dbvis启动时,会自动检测并加载使用:
jar包目录如下:D:\Program Files\dbvis\dbvis_windows_8_0_9\DbVisualizer-8.0.9\jdbc\mysql
tools-->driver manager--->左侧找到mysql驱动的目录, 更新就行
如下附带mysql 最新驱动jar包地址:
http://pan.baidu.com/s/1m2NE2
--本篇文章转自:http://www.cnblogs.com/_popc/p/4053593.html
0 0
- dbvis MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at lin
- dbvis MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at lin
- MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1
- MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT’
- MySQL server version for the right syntax to use near 'type=InnoDB' at line 1
- MySQL server version for the right syntax to use near 'type = InnoDB' at line 25
- your MySQL server version for the right syntax to use near 'NULL' at line 1
- MySQL server version for the right syntax to use near '-1.stu stu0_' at line 1
- MySQL server version for the right syntax to use near ';) T' at line 7
- hibernate自动键表报MySQL server version for the right syntax to use near 'type=InnoDB' at line 1
- hibernate自动键表报MySQL server version for the right syntax to use near 'type=InnoDB' at line 7
- You have an error MySQL server version for the right syntax to use near 'TYPE=InnoDB' at line 20
- MySQL server version for the right syntax to use near 'info where info.stu_id = 1' at line 1
- mysql报错:MySQL server version for the right syntax to use near 'type=InnoDB'
- corresponds to your MySQL server version for the right syntax to use near错误原因之一
- mysql ignore 不能执行MySQL server version for the right syntax to use near ignore问题
- java MySQL server version for the right syntax to use near
- your MySQL server version for the right syntax to use near 'UNION '
- EventBus使用详解(一)——初步使用EventBus
- RecyclerView解析--onViewDetachedFromWindow()/onViewAttachedToWindow()
- EventBus使用详解(二)——EventBus使用进阶
- 获取打印机参数
- 手机号码归属地批量查询软件准确吗?
- dbvis MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at lin
- idea+tomacat运行java web项目总是不成功
- Android中的绘制
- 计划任务配置管理页面
- 用pyqt5创建简单控件
- 浅谈Hadoop(二)——hadoop简介
- 浏览器如IE、谷歌、火狐等,有没有查看cookie的插件?即可以查看当前浏览器中写入的当前用户登录信息有哪些。
- WebStrom(下载、安装、破解、汉化)
- 如何在轮播图片上加入点击事件