sql - SELECT INTO equivalent in mysql -

sql - SELECT INTO equivalent in mysql -

i have been using select * newtable in 'another_database' original_table_in_separate_database; backup/copy info 1 table table in mssql.

now moving mysql , cannot accomplish task feature not available in mysql.

though create table ... select can somehow accomplish task in same database, not 2 different database.

please help me if there thought :)

thanks in advance .

you can utilize insert .. select from build like

insert db1.dbo.newtable select * db2.dbo.original_table_in_separate_database;

point note: insert .. select work both target table , inserting table must exist. otherwise, utilize create table ... select like

create table newtable select * db2.dbo.original_table_in_separate_database;

mysql sql database