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 column_0 AS id, column_1 AS bbb FROM (VALUES ROW(0,'XXX'), ROW(2,'YYY'), ROW(3,'ZZZ') ) AS new; UPDATE Table1 JOIN ( SELECT column_0 AS id, column_1 AS bbb FROM (VALUES ROW(0,'XXX'), ROW(2,'YYY'), ROW(3,'ZZZ') ) AS new ) SELECT * FROM Table1;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear