26
05月
2016
mysql 的union 的用法 如果执行排序 分页操作 必须要把每个sql用括号括起来
$sql = "(select id,title,addtime,sender_id,receiver from fp_message_send where sender_id =".$user_id." and sender_role='1' and status < 8 ) union all(select id,receiver_id,receiver,send_id,status from fp_message_receive where receiver_id= ".$user_id." and receiver_role = '1' and status < 8) order by id DESC limit ".$offset.",". $size;
特殊说明,本文版权归 ning个人博客 所有带原创标签请勿转载,转载请注明出处.
本文标题: mysql的union用法