mohansinfh — 2010-12-25T09:40:36-05:00 — #1
Is there any method to do this in MySQL?
If I have data in a record in MySQL Column, and I want to update the new line of data, without removing the old one.
How to do this?
donboe — 2010-12-25T10:25:06-05:00 — #2
Column1 = 'new_value'
id = 1
mohansinfh — 2010-12-25T10:29:36-05:00 — #3
I did this, but this replaces the old values present in the same record.
I want just like displayed in the above image.
r937 — 2010-12-25T10:52:12-05:00 — #4
SET Column1 = CONCAT(Column1,'New Data')
WHERE id = 1
ibazz — 2010-12-25T21:12:20-05:00 — #5
as ever, rudy's recommendation will work for the issue you presented. However, don't forget to ensure that such an update keeps your database normalised. much better in the longer term.
mohansinfh — 2010-12-26T01:31:06-05:00 — #6
Thank you again Rudy Sir.