Hi! Could we please enable some services and cookies to improve your experience and our website?
create table check2_sql (
id int primary key auto_increment,
ABC varchar(100),
XYZ varchar(100)
);
INSERT INTO check2_sql (ABC, XYZ) VALUES ('AAA', 'BBB');
ALTER TABLE check2_sql ADD COLUMN ABC_XYZ TEXT NOT NULL;
UPDATE check2_sql SET ABC_XYZ = CONCAT(ABC, " ", XYZ);
SELECT * FROM check2_sql;