fork(1) download
copy 
  1. CREATE TABLE my_table
  2. (id INT AUTO_INCREMENT, name varchar(50) null, score decimal(6,2), datestamp date, PRIMARY KEY (id) )
  3. ;
  4. INSERT INTO my_table
  5. (id, name, score, datestamp)
  6. values
  7. (1, 'abc',	10	,	'2015-01-06 00:00:00')	,
  8. (2, '',		20	,	'2015-01-12 00:00:00')	,
  9. (3, NULL,	30	,	'2015-01-10 00:00:00');
  10. SELECT * FROM `my_table` WHERE `name` IS NULL;
Success #stdin #stdout 0s 3360KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
3||30|2015-01-10 00:00:00
https://ideone.com/tKv2gQ
language:
SQLite (sqlite 3.27.2)
created:
9 years 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!