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. INSERT INTO Students (name, faculty, course, degree, specialization)
  11. VALUES
  12. ('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');
Success #stdin #stdout #stderr 0.01s 5280KB
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 10: table Students has no column named faculty