/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

0 vote129 views1 answer
Find largest table in mysql database
SQL
0 vote140 views1 answer
Set mysql socket file docker windows
SQL
5 votes159 views2 answers
Get columns number sql
SQL
0 vote140 views1 answer
Sql mod even odd
SQL
1 vote143 views1 answer
Raise application error in oracle
SQL
0 vote144 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
0 vote145 views3 answers
Duplicate row mysql
SQL
1 vote133 views1 answer
Mysql best tutorial for beginners
SQL
3 votes132 views2 answers
Oracle apex charging debug
SQL
-1 vote87 views1 answer
How to create script to connect to oracle database and run query
SQL