1DROP TABLE IF EXISTS ids; 2CREATE TABLE ids ( 3id DOUBLE, 4value DOUBLE, 5KEY (id, value) 6); 7INSERT INTO ids VALUES ( -1.1, 16.16); 8INSERT INTO ids VALUES ( -2.2, 8.8); 9INSERT INTO ids VALUES ( -4.4, 4.4); 10INSERT INTO ids VALUES ( -8.8, 2.2); 11INSERT INTO ids VALUES (-16.6, 1.1); 12INSERT INTO ids VALUES ( 16.6, -1.1); 13INSERT INTO ids VALUES ( 8.8, -2.2); 14INSERT INTO ids VALUES ( 4.4, -4.4); 15INSERT INTO ids VALUES ( 2.2, -8.8); 16INSERT INTO ids VALUES ( 1.1, -16.16); 17SELECT * FROM ids; 18id value 19-16.6 1.1 20-8.8 2.2 21-4.4 4.4 22-2.2 8.8 23-1.1 16.16 241.1 -16.16 252.2 -8.8 264.4 -4.4 278.8 -2.2 2816.6 -1.1 29SELECT * FROM ids WHERE id BETWEEN -4.5 AND 8.9; 30id value 31-4.4 4.4 32-2.2 8.8 33-1.1 16.16 341.1 -16.16 352.2 -8.8 364.4 -4.4 378.8 -2.2 38DROP TABLE ids; 39