qJL6m85M

1DROP DATABASE IF EXISTS demo;
2CREATE DATABASE demo;
3USE demo;
4CREATE TABLE employees (
5ID INT AUTO_INCREMENT PRIMARY KEY,
6name VARCHAR(255) NOT NULL,
7salary DECIMAL NOT NULL);
8
9INSERT INTO employees (ID, name, salary)
10VALUES (2, 'Ivo', 50000)
11ON DUPLICATE KEY UPDATE 
12employees.salary = employees.salary + salary;
13
14SELECT *
15FROM employees;