Easy ‘create table from view’ syntax in mysql?

You can do CREATE TABLE SELECT from the view to build it. That should duplicate the view’s structure as a new table containing all the view’s rows. Here’s the MySQL syntax reference for this statement.

CREATE TABLE tbl_from_view AS    
  SELECT
    col1,
    col2,
    col3,
    col4,
    col5
  FROM your_view;

Note that you will want to be very explicit in your column selections. It isn’t advisable to do a SELECT * from the source view. Make sure as well that you have aliases for any calculated or aggregate columns like COUNT(*), MAX(*), (col1 + col2), etc.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)