包含数据库相关信息的Sqlite显示表

yxyvkwin  于 2022-12-13  发布在  SQLite
关注(0)|答案(1)|浏览(151)

他们要求我编写一个显示下表的查询:

  • 以字符串形式选择每个表
  • 将属性数选择为整数(计算每个表的属性数)。
  • 使用COUNT(*)函数选择行数
  • 使用复合运算符UNION ALL将这些行绑定在一起。

我该怎么做?
我知道要获取每个表的名称,必须使用

SELECT name AS table_name
  FROM sqlite_schema
 WHERE type = 'table'

但剩下的我就不知道了,你能帮我吗
谢谢你们!
Here you can find the database

disbfnqx

disbfnqx1#

我也有同样的问题,答案归结为“手动”(查看模式可视化或前面提到的输入查询)。〉_〈

SELECT 'Customers' AS table_name, 
       13 AS number_of_attribute,
       COUNT(*) AS number_of_row
  FROM Customers
  
UNION ALL

SELECT 'Products' AS table_name, 
       9 AS number_of_attribute,
       COUNT(*) AS number_of_row
  FROM Products

UNION ALL

SELECT 'ProductLines' AS table_name, 
       4 AS number_of_attribute,
       COUNT(*) AS number_of_row
  FROM ProductLines

UNION ALL

SELECT 'Orders' AS table_name, 
       7 AS number_of_attribute,
       COUNT(*) AS number_of_row
  FROM Orders

UNION ALL

SELECT 'OrderDetails' AS table_name, 
       5 AS number_of_attribute,
       COUNT(*) AS number_of_row
  FROM OrderDetails

UNION ALL

SELECT 'Payments' AS table_name, 
       4 AS number_of_attribute,
       COUNT(*) AS number_of_row
  FROM Payments

UNION ALL

SELECT 'Employees' AS table_name, 
       8 AS number_of_attribute,
       COUNT(*) AS number_of_row
  FROM Employees

UNION ALL

SELECT 'Offices' AS table_name, 
       9 AS number_of_attribute,
       COUNT(*) AS number_of_row
  FROM Offices;

相关问题