mysql 创建视图多表,MySql-创建视图以从多个表中读取

最新推荐文章于 2024-09-05 08:59:19 发布

杨大宝识

最新推荐文章于 2024-09-05 08:59:19 发布

阅读量662

点赞数

文章标签： mysql 创建视图多表

本文介绍如何在MySQL中创建视图来合并`Invoice`表和两个`LineItem`表的数据，以便查询已发送发票的总额及其所有行项目。通过创建一个名为`Invoice_LineItem_All`的MERGE存储引擎表，可以实现从两个LineItem表中检索所有行项目。

摘要由CSDN通过智能技术生成

I have archived some old line items for invoices that are no longer current but still need to reference them. I think I need to create a VIEW but not really understanding it. Can someone help so I can run a query to pull the invoice and then the total of all the line items assigned (no matter what table the items are in)?

CREATE TABLE `Invoice` (

`Invoice_ID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,

`Invoice_CreatedDateTime` DATETIME DEFAULT NULL,

`Invoice_Status` ENUM('Paid','Sent','Unsent','Hold') DEFAULT NULL,

`LastUpdatedAt` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

PRIMARY KEY (`ID`),

KEY `LastUpdatedAt` (`LastUpdatedAt`)

) ENGINE=MYISAM DEFAULT CHARSET=latin1

CREATE TABLE `Invoice_L