SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE employees ( employee_id SERIAL PRIMARY KEY, first_name VARCHAR(50) NOT NULL, middle_name VARCHAR(50) DEFAULT NULL, last_name VARCHAR(50) NOT NULL CHECK (TRIM(last_name) <> ''), hire_date DATE CHECK('2024-01-01' < hire_date AND hire_date < CURRENT_DATE), email VARCHAR(100) UNIQUE, salary DECIMAL(10, 2) DEFAULT 50000.00 ); INSERT INTO employees (first_name, middle_name, last_name, hire_date, email, salary) VALUES ('Иван', NULL, 'Иванов', '2024-09-01', 'ivanov@example.com', 65000.00), ('Анна', 'Сидоровна', 'Иванова', '2024-07-22', 'sidorova@example.com', 85000.00); INSERT INTO employees (first_name, last_name, hire_date, email, salary) VALUES ('Jonn', 'Connor', '2024-04-11', 'connor@example.com', 85000.00); SELECT * FROM employees;