SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE table_1 (name text, quantity int, PRIMARY KEY (name)); INSERT INTO table_1 (name, quantity) VALUES ('Name1', 1); INSERT INTO table_1 (name, quantity) VALUES ('Name1', 1), ('Name2', 1) ON CONFLICT (name) DO UPDATE SET quantity = quantity + 1 ; SELECT * FROM table_1;)
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear