douzhangcuo2174 2014-04-27 10:31
浏览 25
已采纳

如何使用MySQL回显PHP中数据库中每个表中的第一项?

How do I echo out the first item of every table in a adatabase. I know how to do it in one, but not in all. Do I have to use mysql_list_tables() and then get first item with LIMIT? I tried mysql_list_tables(), but it didn't work for some reason.

Could someone help me please?

  • 写回答

1条回答 默认 最新

  • douye2020 2014-04-27 11:19
    关注

    Make a query to information_schema.TABLES (itself a table) to get a list of tables in your database. Then use that list of tables in your PHP code to drive the generation of queries to each table.

    Be careful here. The notion of "first" row in a table is surprisingly fuzzy in the world of RDMSs. If you include ORDER BY you'll have control over it..

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

报告相同问题?

悬赏问题

  • ¥15 电脑开机过商标后就直接这样,求解各位
  • ¥15 mysql , 用自己创建的本地主机和用户名 登录不上
  • ¥15 关于#web项目#的问题,请各位专家解答!
  • ¥15 vmtools环境不正常
  • ¥15 请问如何在Ubuntu系统中安装使用microsoft R open?
  • ¥15 jupyter notebook
  • ¥30 informer时间序列预测
  • ¥20 SSR引物多态性分析
  • ¥15 大漠插件在Win11易语言注册调用和免注册灵异事件,VS上注册调用完全没问题
  • ¥15 Addressable缓存机制做热更新的问题