Am 28.05.2014 21:43, schrieb Rajeev Prasad:
> I am going to have a big table with lot of records, to expedite searching i wanted to
> index on a key field (which is numeric value). BUT, there will be records which will have
> same value for the key field (other columns will be different).
> so how can i do this? right now, i am getting error, about duplicate entries and they
> are being discarded. All entries are important and I have to find a way to locate records
> based on this key field.
who said that a key needs to be unique?
just get phpMyAdmin to learn such things
there you see two different types of keys and after assign you get the sql command
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc