Answers for "mysql query create table from other database"

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.)

Posted by: Guest on August-09-2020

mysql create table from select statement

select * into <NEW_TABLE_NAME> from <OLD_TABLE>;

Posted by: Guest on March-31-2021

Code answers related to "mysql query create table from other database"