By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,985 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,985 IT Pros & Developers. It's quick & easy.

Creating a many to many table

P: 2
can somebody help me create a many to many relationship table, i am having trouble with the syntax error.
1) i want to create a PRODUCT TABLE with two field id and name.
2) i want to then create ORDER TABLE.

3) I then want to create the ORDER_ITEMS TABLE, that will relate between the product and order tables.It should have it primary id, the product table id, the order table id and the quantity ordered in it.
May 4 '12 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 10K+
P: 12,349
You've told us what you want to do. You haven't told us what the problem is.
May 4 '12 #2

P: 2
the problem am having is that i created the product and the order table but the order_items is not executing and its saying mysql syntax error check the manual. so i need the right codes to that will includes the two foreign keys in the order_items table
May 4 '12 #3

Expert Mod 10K+
P: 12,349
You say there's a syntax error but you haven't posted any syntax.
May 4 '12 #4

Post your reply

Sign in to post your reply or Sign up for a free account.