MySQL Forums
Forum List  »  Database Administration & Monitoring

Advanced Search
New Topic

Re: Two databases with one table
Posted by: Tobin Cataldo
Date: August 15, 2012 07:29AM

You can use DML/DDL statements for a table in another database, same instance, using the syntax


`db_name`.`tbl_name`.`col_name`


http://dev.mysql.com/doc/refman/5.5/en/identifier-qualifiers.html

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Two databases with one table
John McCarthy
August 15, 2012 02:09AM
Re: Two databases with one table
Tobin Cataldo
August 15, 2012 07:29AM
Re: Two databases with one table
vignesh shetty
September 01, 2012 06:33AM
Re: Two databases with one table
chen ping
September 04, 2012 08:21PM
Re: Two databases with one table
Yurii Korotia
November 27, 2012 04:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.