LQb6xjsv

1CREATE DATABASE IF NOT EXISTS test;
2USE test;
3
4CREATE TABLE IF NOT EXISTS emp_list(
5id INT UNSIGNED NOT NULL AUTO_INCREMENT primary key,
6first_name VARCHAR(30) NOT NULL,
7last_name VARCHAR(30) NOT NULL,
8job_position  VARCHAR(20) NOT NULL,
9salary decimal(15,2) UNSIGNED,
10);
11
12INSERT INTO emp_list ( id, first_name, last_name, job_position, salary) VALUES ( null, 'Ivan', 'Noscov', 'Director', 69000);
13INSERT INTO emp_list ( id, first_name, last_name, job_position, salary) VALUES ( null, 'Igor', 'Malov', 'Accountant', 54000);
14INSERT INTO emp_list ( id, first_name, last_name, job_position, salary) VALUES ( null, 'Ira', 'Solnceva', 'Salesperson', 27000);
15INSERT INTO emp_list ( id, first_name, last_name, job_position, salary) VALUES ( null, 'Ivan', 'Noscov', 'Security guard', 15000);
16UPDATE employees.emp_list SET last_name = 'Varnaev' WHERE id=4; 
17INSERT INTO emp_list ( id, first_name, last_name, job_position, salary) VALUES ( null, 'Natasha', 'Bolshova', 'Salesperson', 27000);