fork download
copy 
  1. CREATE TABLE Students (id SERIAL PRIMARY KEY, name CHAR(20), age INT, gpa DOUBLE);
  2. ---создать таблицу
  3.  
  4.  
  5. INSERT INTO Students VALUES 
  6. (1, 'Adam', 19, 4.0),
  7. (2, 'Zaqsy', 18, 5.0),
  8. (3, 'aaa', 20, 2.5);
  9. ---заполнить таблицу
  10.  
  11. SELECT * FROM Students;
  12. ---выборка из таблицы
  13.  
  14. ---UPDATE Students SET gpa = 3.5 WHERE name = 'Zaqsy';
  15. ---SELECT * FROM Students;
Success #stdin #stdout 0.01s 5284KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
1|Adam|19|4.0
2|Zaqsy|18|5.0
3|aaa|20|2.5
https://ideone.com/00jquc
language:
SQLite (sqlite 3.27.2)
created:
11 hours 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!