How to "combine" records in tables into one row?

Question

PHP

Hi, I'm doing 3 insert queries because of this, I get a record in 3 lines, how to merge them into one so that the information remains unchanged? Or can this be fixed somehow?

Answer 1

If I understood correctly, you want to fix the created database (there is no possibility to create a new one with this data set? If so, then rewrite the PHP code using UPDATE, take care of having a unique record ID).
In the case of a correction, you can merge 1,2,3 into a new entry #1, remove 2 and 3, and repeat the same for 4, 5, 6 in #4, etc.
What did you have under

information has not changed?

specify.

Answer 2

Use update?

Answer 3

Read on: MySQL String Functions