check the manual that corresponds to your MySQL server version for the right syntax的解决方法
来源:互联网 发布:teambition mac 编辑:程序博客网 时间:2024/05/21 13:19
我在导入一组数据后,进行查询相关操作总是遇到check the manual that corresponds to your MySQL server version for the right syntax的提示。明明写的格式也是对的但就是总报这个提示,百思不得其解。
比如我进行查询tdb_goods表中超极本的价格:
select goods_price from tdb_goods where goods_cate = '超极本';
如下图:
其实写的是相同的,但一个成功一个不成功,成功那个是“超极本”这个字段我从数据库中对应的表直接拷贝过来的。
我觉得出现这个问题,可能是导入人家的数据,字段命名有一些问题,像空格之类什么的影响了查询
所以少年,你对你写的SQL有信心的话,再倒入别人的数据中却找不到或报错可以尝试去数据库直接拷贝人家对应的字段也许就解决了。
0 0
- check the manual that corresponds to your MySQL server version for the right syntax的解决方法
- check the manual that corresponds to your MySQL server version for the right syntax to use
- check the manual that corresponds to your MySQL server version for the right syntax to
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- MySQL:check the manual that corresponds to your MySQL server version for the right syntax
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- MySQL check the manual that corresponds to your MySQL server version for the right syntax
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- MySQL check the manual that corresponds to your MySQL server version for the right syntax错误
- 01-check the manual that corresponds to your MySQL server version for the right syntax
- check the manual that corresponds to your MySQL server version for the right syntax
- check the manual that corresponds to your MySQL server version for the right syntax
- check the manual that corresponds to your MySQL server version for the right syntax
- zstu 2553 滑雪
- Ubuntu 下 VPN 自动连接
- HDU 3726 Graph and Queries
- windows基础编程 - 静态库、动态库文件
- RecyclerView虚线分割线
- check the manual that corresponds to your MySQL server version for the right syntax的解决方法
- CString用法大全
- 学习技巧以及学习方法的总结
- GPS 简单实用-GPRMC
- 笨办法学python_学习笔记1
- table合并单元格
- iOS 开发 -- Swift (七) 函数
- 如何将python程序封装成exe可执行文件
- java对图片进行缩放并保存