Multiple input field data in one mysql table column

djdarpan

Hi,

Can anyone help me!

I have multiple auto generated input fields(e.g. values are 1 to 10) in a form and I want to insert all input fields data in one column of MySQL table. Is there any way to insert these data? Please help me.

Thanks for your help in advance.

Best,

DJ

pbmods

You can concatenate the values using e.g., a comma and then split the string when you retrieve the data. You could also save a serialized or JSON-encoded array.

There is, however, no support in MySQL for saving multiple values to one field in a row.

bartonc

Quote:

Originally Posted by djdarpan

Hi,

Can anyone help me!

I have multiple auto generated input fields(e.g. values are 1 to 10) in a form and I want to insert all input fields data in one column of MySQL table. Is there any way to insert these data? Please help me.

Thanks for your help in advance.

Best,

DJ

As my friend, pbmods, points out; "There is, however, no support in MySQL for saving multiple values to one field in a row.". There is a very good reason for this. The first rule of normalization (1NF) states that data must be atomic (consisting of only one value).

Multiple input field data in one mysql table column

re: Multiple input field data in one mysql table column

re: Multiple input field data in one mysql table column

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about