/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 vote347 views1 answer
Changing name of column and datatype in sql
SQL
0 vote319 views1 answer
Go install mysql
SQL
0 vote332 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
7 votes354 views1 answer
Mysql iif
SQL
3 votes356 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote344 views1 answer
Mysql sql.gz
SQL
2 votes408 views3 answers
Mysql unix timestamp to date
SQL
0 vote333 views1 answer
Oracle sql procedure return value
SQL
0 vote383 views1 answer
Change date in pivot table to month in sql server
SQL
0 vote316 views1 answer
Postgresql remove duplicate rows 2 columns
SQL