/SQL/Mysql create table from select statement

Mysql create table from select statement

Mysql select into new table

-- Insert into existing my_table
INSERT INTO my_table my SELECT * FROM another_table an WHERE an.col1 > 10;
-- or directely create the new table
CREATE TABLE my_table AS SELECT * FROM another_table an WHERE an.col1 > 10;

How to create a table structure from another table in mysql

CREATE TABLE new_tbl LIKE orig_tbl;  //(creates an empty table only definition is
                                        same.)

Source: dev.mysql.com

Mysql select into new table

CREATE TABLE artists_and_works
  SELECT artist.name, COUNT(work.artist_id) AS number_of_works
  FROM artist LEFT JOIN work ON artist.id = work.artist_id
  GROUP BY artist.id;

Source: dev.mysql.com

Mysql create table from select statement

select * into <NEW_TABLE_NAME> from <OLD_TABLE>;

Similar codes

2 votes288 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote302 views1 answer
Psql store procedure-return multiple table values
SQL
4 votes329 views2 answers
Postgresql float data type
SQL
4 votes326 views6 answers
Select sql
SQL
1 vote285 views1 answer
Float precision in psql
SQL
0 vote339 views1 answer
Mysql streaming example
SQL
2 votes296 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
0 vote277 views2 answers
How to save result of sqlite query in a table
SQL
-1 vote295 views2 answers
Postgresql get last 10 records
SQL
1 vote277 views1 answer
Substr sql last character
SQL