How to copy table between two models in Mysql work

Question

I am doing some databese thing, I need copy one table from one model to another, but i try many ways there no effect. Is there any way for doing this?

Answer 1

You can just use a select statement. Here I am creating a duplicate of "original_table" table from the "original_schema" schema/database to the "new_schema" schema :

CREATE TABLE new_schema.duplicate_table AS
Select * from original_schema.original_table;

You can just put any select statement you need ,add a condition and select the columns :

CREATE TABLE new_schema.duplicate_table AS
SELECT column1, column2       
FROM original_schema.original_table
WHERE column2 < 11000000;