469,088 Members | 1,236 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,088 developers. It's quick & easy.

foreign key

I'd like to create a table with PRIMARY KEY k (a,b,c) where a, b, c are
foreign key. Is it possible? How can I do?

Thanks

Bye
Jul 19 '05 #1
6 1778
r
I'm waiting for the answer on this one....
R
"Fabio" <fm*****@yahoo.com> wrote in message
news:cM*****************@tornado.fastwebnet.it...
I'd like to create a table with PRIMARY KEY k (a,b,c) where a, b, c are
foreign key. Is it possible? How can I do?

Thanks

Bye

Jul 19 '05 #2
r
I'm waiting for the answer on this one....
R
"Fabio" <fm*****@yahoo.com> wrote in message
news:cM*****************@tornado.fastwebnet.it...
I'd like to create a table with PRIMARY KEY k (a,b,c) where a, b, c are
foreign key. Is it possible? How can I do?

Thanks

Bye

Jul 19 '05 #3
r
I'm waiting for the answer on this one....
R
"Fabio" <fm*****@yahoo.com> wrote in message
news:cM*****************@tornado.fastwebnet.it...
I'd like to create a table with PRIMARY KEY k (a,b,c) where a, b, c are
foreign key. Is it possible? How can I do?

Thanks

Bye

Jul 19 '05 #4
table one

id - auto increment - primary key - medium int
item - description - text
table two

id - auto increment - primary key - medium int
fk_item_id - medium int
the fk_item_id (foreign key) in table two is really just the primary key of
table one.

A

"r" <no***@nowhere.com> wrote in message
news:99********************@comcast.com...
I'm waiting for the answer on this one....
R
"Fabio" <fm*****@yahoo.com> wrote in message
news:cM*****************@tornado.fastwebnet.it...
I'd like to create a table with PRIMARY KEY k (a,b,c) where a, b, c are
foreign key. Is it possible? How can I do?

Thanks

Bye



Jul 20 '05 #5
table one

id - auto increment - primary key - medium int
item - description - text
table two

id - auto increment - primary key - medium int
fk_item_id - medium int
the fk_item_id (foreign key) in table two is really just the primary key of
table one.

A

"r" <no***@nowhere.com> wrote in message
news:99********************@comcast.com...
I'm waiting for the answer on this one....
R
"Fabio" <fm*****@yahoo.com> wrote in message
news:cM*****************@tornado.fastwebnet.it...
I'd like to create a table with PRIMARY KEY k (a,b,c) where a, b, c are
foreign key. Is it possible? How can I do?

Thanks

Bye



Jul 20 '05 #6
table one

id - auto increment - primary key - medium int
item - description - text
table two

id - auto increment - primary key - medium int
fk_item_id - medium int
the fk_item_id (foreign key) in table two is really just the primary key of
table one.

A

"r" <no***@nowhere.com> wrote in message
news:99********************@comcast.com...
I'm waiting for the answer on this one....
R
"Fabio" <fm*****@yahoo.com> wrote in message
news:cM*****************@tornado.fastwebnet.it...
I'd like to create a table with PRIMARY KEY k (a,b,c) where a, b, c are
foreign key. Is it possible? How can I do?

Thanks

Bye



Jul 20 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Jeremiah Jacks | last post: by
2 posts views Thread by geoff | last post: by
10 posts views Thread by Bodza Bodza | last post: by
4 posts views Thread by Simon Bond | last post: by
10 posts views Thread by Shawn Chisholm | last post: by
2 posts views Thread by Ian Davies | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.