/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

1 vote115 views1 answer
Import sql file mysql commadn line
SQL
5 votes103 views1 answer
Oracle get nls settings
SQL
17 votes112 views6 answers
Mysql import sql file
SQL
22 votes121 views3 answers
How to join three tables in sql using joins
SQL
1 vote119 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote119 views1 answer
Jenkins SQLCMD run
SQL
0 vote124 views1 answer
Groupby sort sql hive
SQL
0 vote130 views2 answers
Reseed sql identity
SQL
1 vote122 views1 answer
Sometimes i cant edit sql developer
SQL
1 vote69 views1 answer
Ms sql - add one hour to time
SQL