mysql views code example

Example 1: mysql views

CREATE VIEW customerPayments
AS 
SELECT 
    customerName, 
    checkNumber, 
    paymentDate, 
    amount
FROM
    customers
INNER JOIN
    payments USING (customerNumber);

Example 2: mysql show views

SHOW FULL TABLES 
WHERE table_type = 'VIEW';

Example 3: mysql show views

SELECT * 
FROM information_schema.tables;

Example 4: views in mysql

views in mysql