fork download
  1. CREATE TABLE Students (id SERIAL PRIMARY KEY, name CHAR(20), age INT, gpa DOUBLE);
  2.  
  3. INSERT INTO Students VALUES
  4. (1, 'Adam', 19, 4.0),
  5. (2, 'Zaqsy', 18, 5.0);
  6. SELECT * FROM Students;
  7.  
  8. UPDATE Students SET gpa = 3.5 WHERE name = 'Zaqsy';
  9. SELECT * FROM Students;
  10.  
  11. INSERT INTO Students (name, direction, course, education_level, practice)
  12. VALUES ('Marat', 'IS', 2, 'bak', 'web'),
  13. ('Adam', 'VT', 2, 'bak', 'sysadmin'),
  14. ('Sam', 'IS', 1, 'mag', 'backend'),
  15. ('Marat', 'IS', 1, 'bak', 'frontend'),
  16. ('Simon', 'VT', 2, 'mag', 'sysadmin'),
  17. ('Marat', 'VT', 1, 'bak', 'frontend');
  18.  
Success #stdin #stdout #stderr 0s 5308KB
stdin
Standard input is empty
stdout
1|Adam|19|4.0
2|Zaqsy|18|5.0
1|Adam|19|4.0
2|Zaqsy|18|3.5
stderr
Error: near line 11: table Students has no column named direction