CREATE TABLE myTable ( id INT, string varchar(100) DEFAULT NULL ); INSERT INTO myTable (id, string) VALUES (1, "First"), (2, NULL); UPDATE myTable SET string = CONCAT(id, " has the value ", string); SELECT * FROM myTable;
What is the output?
Show Answer ▼
