SV: [thelist] MySql - Copy between databases

Jason Handby jasonh at corestar.co.uk
Wed Sep 17 04:16:50 CDT 2003


Hi Ken,

> insert ... select works between tables in a single database. It does not
> seem to work between databases.

You *should* be able to refer to tables in different databases using the dot
notation, e.g.

	INSERT INTO db2.mytable SELECT * FROM db1.mytable

I haven't tried this, but it ought to work.


J



More information about the thelist mailing list