hi there, i dont know if i did something wrong with the merge table or
didnt understand the purpose of it....
so here is what i did, i ve created 2 tables with the same definition
(keys and colums)
then ive create the merge table and replace the primary key by an index
key and every other indexes remain the same.

everything is fine at this stage. So im doing a simple search on the
merge table and it returns nothing! if i do a select * from merge_table,
it returns all the fields. So im wondering why i dont get a result when
i specify a where definition and im sure that it should return a set of
results? Any idea?
Tks

--
Frederic Belleudy
Programmer
PWIdeas
ICQ #: 253-372-030

Please do a 'show create table <table name>\G'
Then we could explore the Merge Table scenario.

----- Original Message -----
From: "Frederic Belleudy" <fredericb@pwideas.com>
To: mysql@lists.mysql.com
Sent: Monday, April 30, 2007 11:14:24 AM (GMT-0500) America/New_York
Subject: mysql merge table

hi there, i dont know if i did something wrong with the merge table or
didnt understand the purpose of it....
so here is what i did, i ve created 2 tables with the same definition
(keys and colums)
then ive create the merge table and replace the primary key by an index
key and every other indexes remain the same.

everything is fine at this stage. So im doing a simple search on the
merge table and it returns nothing! if i do a select * from merge_table,
it returns all the fields. So im wondering why i dont get a result when
i specify a where definition and im sure that it should return a set of
results? Any idea?
Tks

--
Frederic Belleudy
Programmer
PWIdeas
ICQ #: 253-372-030


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=redwards@swmx.com