MySQL Forums
Forum List  »  Newbie

project Quidance Help
Posted by: Antonios Zacharias
Date: January 17, 2024 12:55AM

Hi to all
i need your suggestion about one project i want to make and will use database / Sql

Lets say that i have 5 racks and i want to place in each rack some products.
i want to store in the database the product code and the number of the rack that is stored so i can make a search based on the product code and find the Rack that is stored.
also i want to remove it quite often from the rack

should i make a Database with one Table and add each rack number in columns
or
make a Database with tables for each rack ?

i will add and delete many entries each day (if that has something to do for the best method i should follow)

thanks in advance

Options: ReplyQuote


Subject
Written By
Posted
project Quidance Help
January 17, 2024 12:55AM


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.