User Profile

Collapse

Profile Sidebar

Collapse
etenikoi
etenikoi
Last Activity: May 4 '12, 10:21 PM
Joined: May 4 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • etenikoi
    replied to Creating a many to many table
    in MySQL
    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
    See more | Go to post

      Leave a comment:

    • etenikoi
      started a topic Creating a many to many table
      in MySQL

      Creating a many to many table

      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.
      See more | Go to post
      No activity results to display
      Show More
      Working...