On Thu, Jan 25, 2001 at 12:52:11PM -0600, Gerald L. Clark wrote:
> I would suggest not having 2 cities in your firm record, and making
> fname,city your key.
>
> select * from firms order by fname,city would give you.
> A+B company Dallas
> A+B company London
> New systems Ltd New York
> New systems Ltd Paris
Nice, but it has got some problems. If I correctly understand you, you
suggest me to double records which have got multiple city entries.
The problem is that firms table has got many fields even binary ones
to hold picture data so it would be expensive to double them.
And my other problem: indexing character types are more slower than just bigint
values. By the way is there any ANSI SQL solution for it? I mean only in mySQL
can't be implemented simply or this is a general SQL problem?
PS: Maybe I should stop CC'ing this thread to the list, shouldn't I.
- Gabor Lenart
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
