select content from table1 union all select content from table2
select content from table1 union select content from table2 order by content desc
select content from table1 union select content from table2 where userid = 1 order by content desc
select content from table1 union select content from table2 where userid = 1 order by content,时间order by 就是排序 加上 DESC 倒序
select content from (select userid,username,content,-ascii(content) as fff from content2 union select userid,username,content ,ascii(content) as fff from content1) A order by fff desc
union all
select content from table2
union
select content from table2
order by content desc
union
select content from table2
where userid = 1
order by content desc
union
select content from table2
where userid = 1
order by content,时间order by 就是排序
加上 DESC 倒序
(select userid,username,content,-ascii(content) as fff from content2
union
select userid,username,content ,ascii(content) as fff from content1) A
order by fff desc