MySQL Forums
Forum List  »  Merge Storage Engine

Re: merge and temporary tables
Posted by: Ingo Strüwing
Date: January 31, 2006 03:35AM

For examples, download a MySQL source package. See the files in mysql-test/t. Here is an excerpt from mysql-test/t/merge.test:

create table t1 (a int not null primary key auto_increment, message char(20));
create table t2 (a int not null primary key auto_increment, message char(20));
INSERT INTO t1 (message) VALUES ("Testing"),("table"),("t1");
INSERT INTO t2 (message) VALUES ("Testing"),("table"),("t2");
create table t3 (a int not null, b char(20), key(a)) type=MERGE UNION=(t1,t2);
select * from t3;

The result from this is in mysql-test/r/merge.result:

a b
1 Testing
2 table
3 t1
1 Testing
2 table
3 t2

Regards

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
6041
January 29, 2006 01:22PM
3802
January 30, 2006 03:51AM
3965
January 30, 2006 03:10PM
Re: merge and temporary tables
4678
January 31, 2006 03:35AM


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.