SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE Table1 ( `id` int, `name` varchar(6), `aaa` int, `bbb` varchar(5), PRIMARY KEY (id) ); INSERT INTO Table1 (`id`, `name`, `aaa`, `bbb`) VALUES (0, 'david', 50, 'KTB1'), (1, 'janice', 100, 'TTB1'), (2, 'sam', 150, 'CIMB1'), (3, 'jenny', 200, 'TTB1') ; SELECT * FROM Table1; SELECT 0 AS id, 'XXX' AS bbb UNION ALL SELECT 2 AS id, 'YYY' AS bbb UNION ALL SELECT 3 AS id, 'ZZZ' AS bbb ; UPDATE Table1 JOIN ( SELECT 0 AS id, 'XXX' AS bbb UNION ALL SELECT 2 AS id, 'YYY' AS bbb UNION ALL SELECT 3 AS id, 'ZZZ' AS bbb ) ON Table1.id = new.id SET Table1.bbb = new.bbb SELECT * FROM Table1;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear