check the manual that corresponds to your MySQL server version for the right syntax to use near 'oiw
来源:互联网 发布:head设计模式不会java 编辑:程序博客网 时间:2024/06/05 22:38
删除操作的时候报这个错误,check the manual that corresponds to your MySQL server version for the right syntax to use near 'oiw
检查了下代码,拆分执行没有问题,一起执行的时候有问题。
delete from table1 t1
where t1.id in(
select t2.t1_id from table2 t2 where t2.ids = 3
)
查了文档,可能由于关键字占用的问题、mysql版本的问题
仔细看代码,发现是由于添加了别名,去掉别名,执行成功
0 0
- check the manual that corresponds to your MySQL server version for the right syntax to use near 'oiw
- check the manual that corresponds to your MySQL server version for the right syntax to use near 'cre
- check the manual that corresponds to your MySQL server version for the right syntax to use near '..'
- check the manual that corresponds to your MySQL server version for the right syntax to use near 'USI
- check the manual that corresponds to your MySQL server version for the right syntax to use near '?,?
- check the manual that corresponds to your MySQL server version for the right syntax to use near
- 异常“check the manual that corresponds to your MySQL server version for the right syntax to use near ”
- check the manual that corresponds to your MySQL server version for the right syntax to use near‘XXX’
- CHECK the manual that corresponds TO your MySQL SERVER VERSION FOR the RIGHT syntax TO USE near.....
- check the manual that corresponds to your MySQL server version for the right syntax to use
- heck the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTI
- check the manual that corresponds to your MySQL server version for the right syntax to
- ”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 use“解决
- 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错误
- online_judge_1032
- Android网络编程之TCP通信----简单客户端与服务端通信
- java keytool 自签证书
- mongorestore 恢复mongodump文件报BSONObj size: 17794400 (0x10F8560) is invalid. Size must be between 0 and
- CentOS 配置防火墙操作 配置端口
- check the manual that corresponds to your MySQL server version for the right syntax to use near 'oiw
- python urllib2模块使用方法总结
- 关于图的一些算法
- SSH
- 《programming in scala》study note 上
- 调用摄像头和相册(调用摄像头拍照和从相册中选择图片)
- 新浪滚动新闻的json数据获取页面
- javaWeb 实现上传+下载 文件
- iOS学习笔记(四)——iOS应用程序生命周期