Hi John,
John Kebbel wrote:
INDEXES - A Science AND an Art
I've been continuing to look for answers to my own questions. I've found
a few ...
I meant to write back and try to help, but got busy with other things.
You have found some good answers for yourself.
Q1. What good does it do to s
INDEXES - A Science AND an Art
I've been continuing to look for answers to my own questions. I've found
a few ...
Q1. What good does it do to store the primary key or a unique key if
you're normally SELECTing columns that don't use that primary or unique
key?
"As you can see, it only make
I have a few questions about indexes. I understand (1) what an index
is, and (2) why indexes are useful, but I don't have even a rough idea
about HOW they work. The internet resources I've been able to find don't
answer the questions I'm asking. I also tried
cat /
At 20:15 -0800 10/31/02, Andre Kirchner wrote:
Hi,
is it possible in the mySQL to have an index that none
of the values could be repeated except for a single
value that could be repeated?
Yes, but the only value that can be repeated is NULL.
That's how UNIQUE indexes work for MyISAM and InnoDB
Hi,
is it possible in the mySQL to have an index that none
of the values could be repeated except for a single
value that could be repeated?
The values of the column would be something like this
'123'
'245'
'233'
'XXX'
'XXX'
'027'
where just the value XXX could be repeated.
Thanks,
Andre
___
