Is there any method to do this in MySQL?

Databases
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?

e.g.

957×646 15.4 KB

2 

UPDATE
     your_table
SET
     Column1 = 'new_value'
WHERE
     id = 1
3

I did this, but this replaces the old values present in the same record.
I want just like displayed in the above image.

4 
UPDATE daTable
   SET Column1 = CONCAT(Column1,'New Data')
 WHERE id = 1
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.

6

Thank you again Rudy Sir.