且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在数据库中为单个字段存储多个值

更新时间:2022-12-11 19:40:53

您应该创建一个ADDRESS表,该表具有将其链接到PERSON记录(即PERSON_ID)的外键.这是关系数据库的关系"组件,这就是为什么它比平面文件(就像一个表)更灵活的原因.

You're supposed to create an ADDRESS table that has a foreign key linking it to a PERSON record, i.e. PERSON_ID. This is the "relational" component of a relational database, and it's why it's more flexible than a flat file (which is like a single table).