Re: UNIQUE and INDEX using same field.

[EMAIL PROTECTED] wrote: "Michael J. Pawlowsky" <[EMAIL PROTECTED]> wrote on 10/28/2005 11:28:42 AM: When creating an index in phpMySQL I get a warning message about having 2 indexes using the same field. The table is simply a product comment table. The first index is simply an INDEX on

Re: UNIQUE and INDEX using same field.

"Michael J. Pawlowsky" <[EMAIL PROTECTED]> wrote on 10/28/2005 11:28:42 AM: > > When creating an index in phpMySQL I get a warning message about having > 2 indexes using the same field. > > The table is simply a product comment table. > > The first index is simply an INDEX on the product_id to

UNIQUE and INDEX using same field.

When creating an index in phpMySQL I get a warning message about having 2 indexes using the same field. The table is simply a product comment table. The first index is simply an INDEX on the product_id to speed up displaying them when someone wants to lookup the comments for that product. The s