select * from article,user where article.userid = '1' and article.userid = user.userid or article.userid = '2' and article.userid = user.userid or article.userid = '3' and article.userid = user.userid or article.userid = '4' and article.userid = user.userid or article.userid = '5' and article.userid = user.userid ORDER BY articleid DESC也就是说,userid 会有很多,请问可以精简吗?
解决方案 »
- lock wait timeout exceeded;try restarting transaction
- insert语句的询问!
- 请问环形数据同步在什么情况下使用
- mysql text存放字符数的问题
- 关于mysql数据库备份命令问题
- mysql数据库创建错误,希望尽快得到答复
- 求select * into new_table from old_table的mysql语句
- 我想在程序里实现mysql数据库的备份与恢复
- mysql5.6移动目录以后无法启动
- 请问我这个存储过程会自动回滚吗?还有怎么捕捉错误信息呢?
- MySQL 存储过程异常获取错误码及错误信息
- mysql怎么判断是否为整数?做到整数输出A样式,非整数输出B样式?
where article.userid = user.userid
and article.userid in ('1', '2', '3', '4', '5')
ORDER BY articleid DESC
select * from article,user
where article.userid = user.userid or article.userid in ('1','2','3','4','5')
ORDER BY articleid DESC
这样?
当然还是推荐写括号