Как объединить 2 столбца в MySQL с помощью PhpMyAdmin в один?
Посмотреть:SELECT concat(customers_firstname, ' ', customers_lastname) as customers_fullname FROM `customers`;
Поменять:UPDATE `customers` SET customers_fullname = CONCAT(customers_firstname, " ", customers_lastname);
Посмотреть:SELECT concat(customers_firstname, ' ', customers_lastname) as customers_fullname FROM `customers`;
Поменять:UPDATE `customers` SET customers_fullname = CONCAT(customers_firstname, " ", customers_lastname);