On Fri, Sep 01, 2006 at 03:17:14PM +0530, [EMAIL PROTECTED] wrote: > How to make this work "CREATE TABLE DB2.tblname LIKE DB1.tblname;" It does work perfectly with 5.0. Mabe cross-database queries didn't work with earlier versions? Which version do you use?
> Can we have simultaneous connections with 2 DBs? Using /usr/bin/mysql? Even with one connection you can access as much databases as you like. Even a join of tables from different databases work. bye, -christian- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]