MySQL Forums
Forum List  »  Newbie

Re: Best data type to store lists?
Posted by: Peter Brawley
Date: July 02, 2021 07:57AM

> What is the best way to store a group of employeeIDs on one event record?

You don't. It would break the atomicity rule, the first rule of RDBMSs, one unit of data per cell. If you're going to design a database, you need at least rudimentary knowledge of relational databases, read a primer eg ...

https://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch01.html

https://www.artfulsoftware.com/dbdesignbasics.html

Options: ReplyQuote


Subject
Written By
Posted
Re: Best data type to store lists?
July 02, 2021 07:57AM


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.