MySQL Forums
Forum List  »  Newbie

Getting ready to setup a database for selling stuff
Posted by: Mark Roberge
Date: October 02, 2024 08:42AM

HI,
I have a great deal of experience working with mysql, but now I want to make a database that works. I am thinking that I need two tables. The first one has all of the customers info. The second one I am calling inventory. Now in the inventory table I was thinking that I will use foreign key, item 1 price 1, item 2, price 2 item 3 price 3. Will this work? Do I need to break down table to be something like this instead, item 1 price 1, new table item 2 price 2?
Your help is appreciated, So which do I use?

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.