SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
-- comment CREATE schema seminar_3; CREATE table seminar_3.salary ( employee_nm text, department_nm text, salary_amt numeric(20, 2) ); INSERT INTO seminar_3.salary VALUES ('Петя', 'PR', 100); INSERT INTO seminar_3.salary VALUES ('Вася', 'HR', 120); INSERT INTO seminar_3.salary VALUES ('Даня', 'PR', 100); SET search_path = 'seminar_3'; ALTER table salary add column comment text; UPDATE salary SET comment = 'коммент '|| salary_amt; DELETE FROM salary WHERE employee_nm = 'Петя'; SELECT * FROM salary; --SELECT * FROM seminar_3.salary WHERE department_nm='PR';
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear