Please do a 'show create table <table name>\G' Then we could explore the Merge Table scenario.
----- Original Message ----- From: "Frederic Belleudy" <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]