[MariaDB] Sample - CREATE VIEW

 

Sample Code : CREATE VIEW

# =======================================================
CREATE VIEW employee_info AS
SELECT employee_id, first_name, last_name, salary
FROM employees


# =======================================================

CREATE VIEW IF NOT EXISTS employee_info
SELECT employee_id, first_name, last_name, salary
FROM employees