How create new table from a MySQL SELECT statement

Discussion in 'HOWTO-Related Questions' started by zayde, Sep 1, 2013.

  1. zayde

    zayde New Member

    Using MySQL 5 I would like to insert the results of a SELECT statement into a temporary table that would be created automatically. Is that possible ?
  2. till

    till Super Moderator Staff Member ISPConfig Developer

  3. zayde

    zayde New Member

    creating a temporary table from a SELECT

    till, your suggestion appears to require the new table to already be defined. I want it to be created automatically.

    But your link led me to the solution:
    create temporary table tmp_tbl as SELECT .......

    The online manuals are so difficult to search. I didn't post my request until I had spent hours searching the MySQL manual.


Share This Page