在单个MYSQL单元格中插入多个值

Question

Can anyone suggest me how can i store Multiple values in a single MySQL cell using Php? I am simply using the insert function but it is not helpfull at all.

Answer 1

No, no no, no, NO!

Never store multiple values in a single cell. It will always get back to you. It is against the 3rd rule of DB normalization.

Insert only single values in a cell and add multiple records if you must. Example

photos table:          id  | filename
                       1   | 'myfoto.jpg'

comments table:       photo_id | user_id  | comment
                      1        | 23       | 'great picture'
                      1        | 99       | 'nice'
                      1        | 7        | 'do not like it'