/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

1 vote148 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
5 votes151 views1 answer
Commentaire table oracle
SQL
10 votes154 views1 answer
Oracle dba_dependencies
SQL
0 vote144 views1 answer
Oracle job class
SQL
0 vote168 views1 answer
Repeatable read trong sql server
SQL
27 votes151 views4 answers
Get all tables with column name sql
SQL
0 vote162 views1 answer
Count in sql and diff
SQL
0 vote150 views1 answer
Mysql count with two joins
SQL
0 vote157 views1 answer
Select * from mysql.proc
SQL
0 vote175 views2 answers
Oracle ora-00054 how to unlock
SQL