1 SELECT strftime('%s','now');
2 CREATE TABLE test (x INT, `key` VARBINARY(200));
3 SELECT * FROM test WHERE x IS NOT NULL;
4 CREATE INDEX `key` ON test(`key`(20));
5 SELECT avg(x) FROM test;
6 SELECT count(*) FROM test;
7 CREATE TABLE appointments (alert_at DATETIME);
8 INSERT INTO `appointments` (
11 NOW() + INTERVAL @delay SECOND
13 SELECT SUM(CASE WHEN x > 10 THEN 1 ELSE 0 END) FROM test;
14 -- delete from txn_ranges
15 -- where id in (@tr1_id, @tr2_id)
16 -- and not exists (select 1 from workareas where txn_range_id = txn_ranges.id)