SQLize Online / PHPize Online  /  SQLtest Online

CREATE schema seminar_3; CREATE table seminar_3.salary ( employee_nm text, department_nm text, salary_amt numeric(20,2) ); SELECT * FROM information_schema.tables WHERE table_name = 'salary'; SET search_path = 'seminar_3'; INSERT INTO seminar_3.salary VALUES ('Петя Иванов', 'АЙТИ', 10); INSERT INTO seminar_3.salary (employee_nm, salary_amt) VALUES ('АЙТИ', 30000); DELETE FROM seminar_3.salary WHERE employee_nm = 'АЙТИ'; ALTER table salary ADD COLUMN comment text; UPDATE salary set comment = 'Комментарий для строки ' || salary.employee_nm; DROP table salary; ALTER table salary DROP COLUMN comment; SELECT * FROM seminar_3.salary;