How to update data in a database without deleting old data?

Question

I would like to know how to do this. let's say I have this “first” in my database, and if I want to update and add a “second”, in which I can have this format “first, second”. I used this one UPDATE table SET number="second", but it removes the "first". I use php and mysql, thanks

Answer 1

I think you mean:

// if number is "first", it will become "first, second"
UPDATE table SET number = CONCAT(number, ", second")

but I do not think you need. Can you explain what you are trying to do?

Answer 2

UPDATE table SET number=concat_ws(",", number, "second")

Answer 3

, . -, .

, , , :

• : , . - , .

• Sous code control . Save the code in the Source Control section so that you can revert to previous versions as needed.

• Separation of Prod and Dev . If you play Production, you can do a lot of damage. Make double triple sure that you work in an isolated environment.