【mysql】view

Viewの作成

create view drink_products
as
select id, name from products where category = 'drink';

Viewの定義の確認

show create view drink_products;

Viewの変更

alter view drink_products
as
select id, name from products where category = 'drink';

createの箇所がalterになっただけで他は同じcreateと同じ構文。