Ok, I don't know exactly how to word this as I've never heard or done this but I'm sure someone has. Basically what I am doing is creating a listing for businesses, where fields such as phone numbers, other legal names, SIC codes, etc can have multiple values inserted into a column, for example there can be many phone numbers inserted into the phone number column in the table for that business. How would you achieve this both in mysql and php? Thanks!
2条回答 默认 最新
- dongpingwu8378 2012-11-16 19:54关注
This can be done with what's called a many-to-one[1] relationship.
You have a
company
table, which would hold fields such ascompanyID
,name
, etc (all the single values (one-to-one) values).Then, you have a
phones
table, which would reference the originalcompanyID
, while providing the information in multiple rows. For example:company ------- id | name 1 | Stack Overflow 2 | Hello World! phones ------ comapnyID | phoneID | number 1 | 1 | 1234567890 1 | 2 | 0987654321 2 | 3 | 1234509876
This represents company 1 having two phone numbers, and company 2 having one.
You can easily select those with a MySQL JOIN clause.
1: One company may have multiple phone numbers, but a phone number can only belong to one company.
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报
悬赏问题
- ¥15 BP神经网络控制倒立摆
- ¥20 要这个数学建模编程的代码 并且能完整允许出来结果 完整的过程和数据的结果
- ¥15 html5+css和javascript有人可以帮吗?图片要怎么插入代码里面啊
- ¥30 Unity接入微信SDK 无法开启摄像头
- ¥20 有偿 写代码 要用特定的软件anaconda 里的jvpyter 用python3写
- ¥20 cad图纸,chx-3六轴码垛机器人
- ¥15 移动摄像头专网需要解vlan
- ¥20 access多表提取相同字段数据并合并
- ¥20 基于MSP430f5529的MPU6050驱动,求出欧拉角
- ¥20 Java-Oj-桌布的计算