View in mysql syntax

This article is tagged with: View in mysql syntax and mysql

view in mysql syntax

CREATE VIEW view_name AS
SELECT column1, column2, ...
FROM table_name
WHERE condition;

query view mysql php

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

This article is tagged with: View in mysql syntax and mysql