fork download
copy 
  1. (20)  скачать copy
  2. CREATE TABLE Students (id SERIAL PRIMARY KEY, name CHAR(20), age INT, gpa DOUBLE);
  3.  
  4. INSERT INTO Students VALUES 
  5. (1, 'Adam', 19, 4.0),
  6. (2, 'Zaqsy', 18, 5.0);
  7. SELECT * FROM Students;
  8.  
  9. UPDATE Students SET gpa = 3.5 WHERE name = 'Zaqsy';
  10. SELECT * FROM Students;
Success #stdin #stdout #stderr 0s 5304KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: near line 1: near "(": syntax error
Error: near line 4: no such table: Students
Error: near line 7: no such table: Students
Error: near line 9: no such table: Students
Error: near line 10: no such table: Students
https://ideone.com/NRhHOe
language:
SQLite (sqlite 3.27.2)
created:
10 days ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!