fork download
copy 
  1. CREATE TABLE customer (name VARCHAR(50),age INT,salary INT, address VARCHAR(100));
  2.  
  3. INSERT INTO customer (name, age, salary, address) VALUES ('arun', 45, 25000, 'chennai');
  4. INSERT INTO customer (name, age, salary, address) VALUES ('gopal', 47, 30000, 'kanchipuram');
  5.  
  6. SELECT * FROM customer;
  7.  
  8. SELECT COUNT(*) FROM customer;
  9.  
  10.  
  11. SELECT * FROM customer WHERE salary > 26000;
  12. DROP TABLE customer;
  13. SELECT * FROM customer;
Success #stdin #stdout #stderr 0s 5308KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
arun|45|25000|chennai
gopal|47|30000|kanchipuram
2
gopal|47|30000|kanchipuram
stderr
copy 
Error: near line 13: no such table: customer
https://ideone.com/NzgjXy
language:
SQLite (sqlite 3.27.2)
created:
2 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!