视图转表

CREATETABLE tbl_from_view ASSELECT
    col1,
    col2,
    col3,
    col4,
    col5
  FROM your_view;