douzen3516 2017-04-28 11:55
浏览 405
已采纳

如何从MySQL中的多个表循环数据?

I have these tables with the following columns:

Article

1.1. title
1.2. text
1.3. sortnr

Congress

2.1. title
2.2. text
2.3. sortnr

And, obviously, others, but these are the ones that are the same. And what I'd like to do is write a query where I can then loop through these fields as if they were from one table.

What it looks like:

SELECT * FROM article, congress ORDER BY sortDate DESC LIMIT 3

but with that I can't use fields like title and so on because during the loop, all the, for example, title fields are being turned in to the ones from congress table.

Is there a way to mix the two tables and treat them like they were from one table considering that they aren't joined in any way?

  • 写回答

1条回答 默认 最新

  • doufu1504 2017-04-28 11:59
    关注

    Try this:

    SELECT *, 'article' as tblnm FROM article
    UNION
    SELECT *, 'konferansenentry' as tblnm FROM konferansenentry 
    ORDER BY sortDate DESC 
    LIMIT 3
    

    It will only work if both table have same field other wise you have to select individual one by one.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥20 有人知道这种图怎么画吗?
  • ¥15 pyqt6如何引用qrc文件加载里面的的资源
  • ¥15 安卓JNI项目使用lua上的问题
  • ¥20 RL+GNN解决人员排班问题时梯度消失
  • ¥15 统计大规模图中的完全子图问题
  • ¥15 使用LM2596制作降压电路,一个能运行,一个不能
  • ¥60 要数控稳压电源测试数据
  • ¥15 能帮我写下这个编程吗
  • ¥15 ikuai客户端l2tp协议链接报终止15信号和无法将p.p.p6转换为我的l2tp线路
  • ¥15 phython读取excel表格报错 ^7个 SyntaxError: invalid syntax 语句报错