解决方案 »
- show innodb status有关Spin Waits,Spin Rounds,Os Waits是如何解释的
- Checking for corrupt, not cleanly closed and upgrade needing tables..
- 求助,mysql里面看不到用户信息的数据库了,在线等
- 复制从机器如何处理复制表的数据更新
- MYSQL编码问题
- pgsql中时间函数怎么写?快点来结贴快
- mysql如何实现高效的搜索?
- 菜鸟问题 MYSQL
- 【求助】mysql事务回滚的问题
- order by 一个索引字段没有起效的疑惑
- 有关于索引,我有些不明白的地方,在这里请教各位大神了
- 用户手册用什么工具写比较好一些啊,求大神指点
select a1.id,a2.tagid from (
select a.* from a left join b on a.id=b.imgid where b.imgid is null) a1
inner join
(select a.* from a inner join b on a.id=b.imgid ) a2
on a1.title=a2.title
select a1.id,a2.tagid from (
select a.* from a left join b on a.id=b.imgid where b.imgid is null) a1
inner join
(select a.* ,b.tagid from a inner join b on a.id=b.imgid ) a2
on a1.title=a2.title
多谢了!!!