mysql 合并两表的相同字段

 

(SELECT ts.products_id,ts.sort from top_selling ts)

union(SELECT na.products_id,na.sort from new_arrival na)

order by rand()

limit 4

本文永久地址:https://sjolzy.cn/mysql-merge-two-tables-in-the-same-field.html

--EOF--

标签: SELECT, limit, rand, url, union

随机文章

添加新评论