MySQL Forums
Forum List  »  Replication

Replication vs temporary table
Posted by: Francois Debly
Date: April 26, 2005 02:25AM

Do the replication support the creation of temporary table ?
Is there any particular configuration point to focus on ?

For instance:

create temporary table t1(ext int, index(ext)) type=HEAP;
create temporary table t2(ext int, index(ext)) type=HEAP;

insert into t1 select 0+substring(alias, 5) as val from User where (alias like 'CHAT%' and (0+substring(alias, 5) != 0) or alias='CHAT');
insert into t2 select t1.ext+1 from t1;
select t2.ext from t2 left join t1 on (t2.ext=t1.ext) where t1.ext is NULL order by t2.ext limit 1;
drop table t1; drop table t2;

What is executed on the slave side ?

Many thanks in advance,


Options: ReplyQuote

Written By
Replication vs temporary table
April 26, 2005 02:25AM

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.