mysql question

[Justin]

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

 

[Gordon Beaton]

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

 

[Furious George]

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.

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?

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

 

[Justin]

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

 

[Andrew Thompson]

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.

 

[Justin]

i am no troll. i take offense to that.

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

Andrew T.

 

[Jeffrey Schwab]

i am no troll. i take offense to that.

Much better. That's the spirit!

 

[Rhino]

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