maysql 报错＞ 1221 - Unknown error 1221

mysql出现> 1221 - Unknown error 1221

1.当我们拼接2条sql时，就会用到 union all 和union
union all 和 union的区别是
union：会把两个查询语句的结果集合并起来，会过滤掉两个结果集中重复的行。
union all：不会过滤掉重复行，把所有的数据查询出来
2.报错的原因是，我们写的2条sql
查询时 每一条都使用了order by
3.解决办法有两个
1.1

(SELECT A,B,C FROM `s` ORDER BY A DESC) 
UNION 
(SELECT A,B,C FROM `r` ORDER BY B DESC);

1.2

SELECT * FROM 
(SELECT A,B,C FROM `s` ORDER BY A DESC)
 AS t1 
 UNION 
 SELECT A,B,C FROM `r` ORDER BY B DESC;