一个 sql 语句如下:select id from( selec ....
union
selec ....
union
selec ....
union
selec ....
union
selec ....) as e
where 1=1 and exist ( select eventid from a where..e.e.r.e) as b order by datetime descexist走全表 ,我准备用inner join 替换结果总是失败 , 提示 2个 ( selec ....
union
selec ....
union
selec ....
union
selec ....
union
selec ....) as e( select eventid from a where..e.e.r.e) as b
不能用inner join (left right join都失败)问有什么方法啊可以不用exist
union
selec ....
union
selec ....
union
selec ....
union
selec ....) as e
where 1=1 and exist ( select eventid from a where..e.e.r.e) as b order by datetime descexist走全表 ,我准备用inner join 替换结果总是失败 , 提示 2个 ( selec ....
union
selec ....
union
selec ....
union
selec ....
union
selec ....) as e( select eventid from a where..e.e.r.e) as b
不能用inner join (left right join都失败)问有什么方法啊可以不用exist
解决方案 »
- 用mysqldump导出整个数据库时,能不能不导某些表数据?(顶有分)
- 急问 ACCESS数据如何转换成MYSQL
- 请问,存储过程里的IF字符串比较只能用strcmp吗?直接用'a'='a'会报错啊……
- 大家最希望 mysql proxy 具备什么功能
- 北京出售全新《数据库系统概念(原书第4版)》。。。48元。。。
- 多进程存贮mysql时,出现认证错误(unauthenticated user)
- 怎样在mysql中使用innoDB表
- 一条sql 语句!
- 高分解答,一个小问题,进来看看!
- 数据库异常
- 连接局域网里mysql数据库时无法连接
- ado方式调用mysql的存储过程数据量少时正常,大数据量异常
and exist ( select eventid from a where..e.e.r.e) as b order by datetime desc
这个如何用in???