hi, good day, as showing below code was my
testing code to get index name from respective table
description : - there are 5 tables :newcampaign,newcompany,newcompetitor,newcomplaint,newtable2
- only newtable2 have index with named newindex
- newcampaign have a primary key , the rest table don't not have primary key
problem: when the following code run, it suppose to show me the result only "index:newindex" , but as shown in below result, it give me few "index:PRIMARY" ..anyone why is it so ?
for your info : if i run the SQL statement in MYSQL with "show index from newcampaign" , it do give me one record ..even i didn't set index for newcampaign table but only primary key
result :
index:PRIMARY
index:PRIMARY
index:PRIMARY
index:PRIMARY
index:newindex
thank you very much for your time and your help is highly appreciated
[edited to disable smilies in :PRIMARY]
[ December 20, 2004: Message edited by: Jeanne Boyarsky ]