/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

2 votes171 views1 answer
How to delete columns in sql
SQL
7 votes180 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
0 vote201 views1 answer
Declaring variables in pl sql
SQL
0 vote196 views1 answer
Remove transient options sql wordpress
SQL
1 vote187 views1 answer
List all triggers in SQL Server
SQL
6 votes180 views1 answer
Wordpress change user password sql
SQL
10 votes175 views1 answer
Create table oracle
SQL
0 vote224 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote185 views1 answer
Mssql now diff 90 day
SQL
0 vote232 views1 answer
Import sql inside hide sql
SQL