I'm having trouble getting MySQL's union join to work when merging tables
from different databases. MySQL complains with "ERROR 1017: Can't find file:
'total.MRG' (errno: 2)" even though this file exists.
Here are the commands I use to produce the error. Please let me know how I
can get union joins working. Thanks!
create database v1;
use v1;
create table v1 (type varchar(10), price double);
insert into v1 (type, price) values ('cheap','10');
create database v2;
use v2;
create table v2 (type varchar(10), price double);
insert into v2 (type, price) values ('pricy','50');
create database total;
use total;
create table total (type varchar(10), price double)
type=merge union=(v1.v1, v2.v2);
Up to this point MySQL is happy. Then, when I say:
select * from total;
MySQL responds with:
ERROR 1017: Can't find file: 'total.MRG' (errno: 2)
The file exists. I have permissions to use it. Again, how can I do union
joins across multiple databases?
Thanks
David Newman
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
