Answers for "create a mysql table from already existing table with data"

SQL
1

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

Code answers related to "create a mysql table from already existing table with data"

Code answers related to "SQL"

Browse Popular Code Answers by Language