Rick Emery wrote:
>
> First: I believe this is not legal (looking at myySQL manual p 6.5.3):
> PRIMARY KEY (key1), KEY (key2)
> You may use one or the other.
yup, it does work here, ver 3.23.42.
> Second: You may search by either owner_id or customer_id without creating an
> index.
> Such as
thanks for the reply. it seems to be clear now.
> MySQL Doesn't allow you to specifiy which index to use - it chooses
> (sometimes badly) whether or not to use one.
From documentation:
As of MySQL Version 3.23.12, you can give hints about which index
MySQL should use when retrieving i
hi,
i'm not sure if this belongs here, but i cannot seem to find the
answer anywhere else.
first, what's the difference between:
PRIMARY KEY (key1, key2)
PRIMARY KEY (key1), KEY (key2)
second, let's suppose the following table:
owner_id int(11),
customer_id int(11),
customer_in
