mysql inserting data from one schema to another

Question

Is there a way to insert data from a table in schema1 to a table in schema2 in mysql.

Also , I assume there will be any access/privilege issues.

My environment is Joomla using Fabrik extension, PHP, MySQL

Kindly share some tips

Thanks in advance

Answer 1

You can always preface the table name with the database name and as long as the user has the appropriate permission you can do:

insert into db1.users( first, middle, last )
select a.first, a.middle, a.last from db2.users a

See the following for the documentation insert .. select

Answer 2

This query does that:

INSERT INTO db2.table1 SELECT * FROM db1.table1;

• Not tested but should do the job.

If you do this as root user, you will have no permission issues.

• Backup your data first, though.