Re: searching in 2 databases?

2002-08-12 Thread Victoria Reznichenko
Ilyas, Monday, August 12, 2002, 11:22:52 AM, you wrote: IK> Is it possible in Mysql to search in 2 databases with only one search IK> statement? Do you mean use tables from different database? If the databases are located on the same MySQL server - yes. For example: SELECT * FROM database1.a,

Re: searching in 2 databases?

2002-08-12 Thread Gelu Gogancea
PROTECTED] [EMAIL PROTECTED] - Original Message - From: "Ilyas Keser" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 12, 2002 11:22 AM Subject: searching in 2 databases? > > Is it possible in Mysql to sea

searching in 2 databases?

2002-08-12 Thread Ilyas Keser
Is it possible in Mysql to search in 2 databases with only one search statement? Thanks ilyas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar