Product Solutions Support
Try MemSQL

CREATE VIEW

Create an unmaterialized view.

CREATE
    [DEFINER = { user | CURRENT_USER }]
    VIEW view_name
    AS select_statement

Notes

Examples

memsql> CREATE VIEW view_name
 -> AS SELECT * FROM table_name WHERE user_id = "real_person";

memsql> create view active_items_view as
 -> select * from items where status = 'active';

memsql> create view discounted_items_view as
 -> select * from active_items_view where discount = 1;
Was this article useful?