mysql question

Thread view:

Justin - 14 Oct 2006 02:26 GMT

off subject, however, this is an intelligent group and I am sure
someone can answer my question. I've been scouring the internet, and
cannot find an answer. I have a MySQL database that I've created. I
have a bunch of tables that are all have one-to-many relationships.

>From my access experience, when you relate two tables, you create an

autolookup column in the child table of a one-to-many relationship. Do
you do something similar in sql? If so, what would this command look
like?

Thanks

Reply to this Message

Gordon Beaton - 14 Oct 2006 08:37 GMT

> off subject, however, this is an intelligent group and I am sure
> someone can answer my question. I've been scouring the internet, and
> cannot find an answer.

While scouring the internet, did it never occur to you that there
might be newsgroups where this *isn't* off topic?

http://groups.google.com/ and http://dir.gmane.org/ both have boxes
where you can search for appropriate groups.

/gordon

Signature

[ don't email me support questions or followups ]
g o r d o n + n e w s @ b a l d e r 1 3 . s e

Reply to this Message

Justin - 14 Oct 2006 17:16 GMT

Indeed it did. However those groups dont have a lot of activity, and I
am very impatient.

> > off subject, however, this is an intelligent group and I am sure
> > someone can answer my question. I've been scouring the internet, and
[quoted text clipped - 11 lines]
> [ don't email me support questions or followups ]
> g o r d o n + n e w s @ b a l d e r 1 3 . s e

Reply to this Message

Andrew Thompson - 14 Oct 2006 18:40 GMT

> Indeed it did. However those groups dont have a lot of activity, and I
> am very impatient.

That is a very poor imitation of a troll. :-(
Please apply more effort in future.

Andrew T.

Reply to this Message

Justin - 14 Oct 2006 19:18 GMT

i am no troll. i take offense to that.

> > Indeed it did. However those groups dont have a lot of activity, and I
> > am very impatient.
[quoted text clipped - 3 lines]
>
> Andrew T.

Reply to this Message

Jeffrey Schwab - 14 Oct 2006 19:46 GMT

> i am no troll. i take offense to that.
>
[quoted text clipped - 4 lines]
>>
>> Andrew T.

Much better. That's the spirit!

Reply to this Message

Rhino - 15 Oct 2006 06:34 GMT

> Indeed it did. However those groups dont have a lot of activity, and I
> am very impatient.

Is that a synonym for "too lazy to post a question on an appropriate forum
and actually wait for an answer"?

For your information, the general MySQL forum is quite active; as a
subscriber, I see dozens of posts a day on a normal day.

--
Rhino

>> > off subject, however, this is an intelligent group and I am sure
>> > someone can answer my question. I've been scouring the internet, and
[quoted text clipped - 11 lines]
>> [ don't email me support questions or followups ]
>> g o r d o n + n e w s @ b a l d e r 1 3 . s e

Reply to this Message

Furious George - 14 Oct 2006 12:06 GMT

> off subject, however, this is an intelligent group and I am sure
> someone can answer my question. I've been scouring the internet, and
[quoted text clipped - 5 lines]
> you do something similar in sql? If so, what would this command look
> like?

This is a foreign key constraint. You can find it in the MySQL
documentation.

> Thanks

Reply to this Message

mysql question

Free Magazines