Creates a stored query in the MariaDB ColumnStore
CREATE [OR REPLACE] VIEW view_name [(column_list)] AS select_statement
Notes to CREATE VIEW:
CREATE VIEW v_cust_orders (cust_name, order_number, order_status) as select c.cust_name, o.ordernum, o.status from customer c, orders o where c.custnum = o.custnum;
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.