<div>
Are you switching over to the database first:<br />
<br />
\u events<br />
<br />
Then the query<br />
<br />

</div>


Are you switching over to the database first:

\u events

Then the query



<div>
database was switched over first. &nbsp;
</div>


<div>
Has this helped you, or is more needed?<br />
Moondancer - EE Moderator
</div>


Has this helped you, or is more needed?
Moondancer - EE Moderator

<div>
I was able to solve this one on my own. &nbsp;It seems that the merged tables have to have identical primary and key fields. &nbsp;I had made a mistake in declaring one of those fields. &nbsp;I shall give moon dancer credit since he had the closest answer.<br />
<br />
Thanks guys.
</div>


I was able to solve this one on my own.  It seems that the merged tables have to have identical primary and key fields.  I had made a mistake in declaring one of those fields.  I shall give moon dancer credit since he had the closest answer.

Thanks guys.

<div>
<div class="content wysiwyg-content">
creating a merged table with the following command within the events database. &nbsp;The m2001_11 and m2001_12 tables are within the events table as well.<br />
<br />
create table mergedArchiveTable (nsid varchar(10), utime int(10), eam_id bigint(20)) type=merge union=(m2001_12, m2001_11);<br />
<br />
select * from mergedArchiveTable;<br />
<br />
ERROR 1016: Can't open file: 'mergedArchiveTable.MRG'. (errno: 143)<br />
<br />
Why is this occuring?
</div>
</div>


creating a merged table with the following command within the events database.  The m2001_11 and m2001_12 tables are within the events table as well.

create table mergedArchiveTable (nsid varchar(10), utime int(10), eam_id bigint(20)) type=merge union=(m2001_12, m2001_11);

select * from mergedArchiveTable;

ERROR 1016: Can't open file: 'mergedArchiveTable.MRG'. (errno: 143)

Why is this occuring?

Can't open file

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.