How to merge 2 columns in MySQL using PhpMyAdmin into one?

Question

MySQL

Let's say there is a customers table.
It has columns customers_firstname and customers_lastname.
It is necessary to combine them so that the textual information from them is displayed through a space in one column.
Those. was separately customers_firstname: Ivan , customers_lastname: Ivanov
and will be in the customers_firstname field (then I will rename or you can immediately create a new one): Ivan Ivanov

Answer 1

Look:
Change:

UPDATE `customers` SET customers_fullname = CONCAT(customers_firstname, " ", customers_lastname);

Answer 2

https://habrahabr.ru/post/305926/