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?
Column1 = 'new_value'
id = 1
I did this, but this replaces the old values present in the same record.I want just like displayed in the above image.
SET Column1 = CONCAT(Column1,'New Data')
WHERE id = 1
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.
Thank you again Rudy Sir.