Answers for "views in mysql"

mysql show views

SHOW FULL TABLES 
WHERE table_type = 'VIEW';

Posted by: Guest on November-03-2020

mysql show views

SELECT * 
FROM information_schema.tables;

Posted by: Guest on November-03-2020

query view mysql php

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

Posted by: Guest on September-06-2020

Code answers related to "views in mysql"