Insert multiple values in one field?
Posted: Fri Mar 26, 2010 9:59 am
I want to fix data redundancy in my database.
Is it posible to insert more than one values into one field, and maybe I will need doing some calculation using the values.
This is my database, generating two rows.
Instead of those, I want to insert multiple values in one field like this.
thanks.
Is it posible to insert more than one values into one field, and maybe I will need doing some calculation using the values.
This is my database, generating two rows.
Code: Select all
---------------------------------
id_order | buyer | price | product
---------------------------------
000001 | John | 750 | prod1
---------------------------------
000001 | John | 750 | prod2
--------------------------------
Code: Select all
--------------------------------------
id_order | buyer | price | product
--------------------------------------
000001 | 500 | 750 | prod1, prod2
--------------------------------------