Hi,
Sorry for the possible offtopic question I'm going to ask.
I have got something similar (this is very simplicated situation of
my problem but this is the core of my headache):
CREATE TABLE cityname (
id BIGINT NOT NULL AUTO_INCREMENT,
cname CHAR(50),
INDEX id_index(id)
);
CREATE TABLE firms (
id BIGINT NOT NULL AUTO_INCREMENT,
fname CHAR(50),
city0 BIGINT,
city1 BIGINT,
INDEX id_index(id),
INDEX city0_index(city0),
INDEX city1_index(city1)
);
Now I want to dump data out from my database with textual names of cities.
if I do:
SELECT * FROM firms;
it's not good since I have to resolve the city names in further queries which
seems to a bit expensive (inmagine that each record has got 6 cities.
note that I had to use maximum of 6 cities so I don't want to create another
table for the relation, but please ask me to this - and tell me how and why
is it better - if it's better solution).
What can I do to have something similar result:
A+B company Dallas London
New systems Ltd New York Paris
My knowledge in this situation is not enough for talking about mysql.
Please help me, and CC the letter for me as well, since I'm not on any
mysql mailing list.
Maybe my SQL knowledge is not too good as well to ask such a stupid question :)
By the way, where can I ask questions like this especially for MySQL? Maybe
I should read some documents can be found on the net ... Tell URLs.
Or whatever.
Thanx a lot: Gabor Lenart ([EMAIL PROTECTED])
---------------------------------------------------------------------
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