create a new view in mysql workbench code example

Example: create view in mysql workbench

CREATE [OR REPLACE] VIEW [db_name.]view_name [(column_list)]
AS
  select-statement;