ตอนที่ 13 : การสร้าง VIEW Table บน MySQL Database (MySQL : View Table)

CREATE OR REPLACE VIEW `view_name` AS
            // Statement

CREATE OR REPLACE DEFINER=`root`@`localhost` VIEW `view_name` AS
            // Statement

CREATE OR REPLACE VIEW customer_info AS

SELECT     A.CUSTOMER_ID, A.NAME, B.COUNTRY_NAME, A.BUDGET, A.USED, COUNT(C.AUDIT_ID) AS ITEM_AUDIT
FROM         CUSTOMER AS A LEFT OUTER JOIN
                      COUNTRY AS B ON A.COUNTRY_CODE = B.COUNTRY_CODE LEFT OUTER JOIN
                      AUDIT AS C ON A.CUSTOMER_ID = C.CUSTOMER_ID
GROUP BY A.CUSTOMER_ID, A.NAME, B.COUNTRY_NAME, A.BUDGET, A.USED;

SELECT * FROM customer_info

SELECT * FROM customer_info WHERE ITEM_AUDIT >= 3