DROP TABLE IF EXISTS items;
CREATE TABLE items (
name VARCHAR(255),
price TINYINT KEY
) DEFAULT CHARSET=utf8;
INSERT INTO items VALUES ("hamburger", 120);
INSERT INTO items VALUES ("discount", -10);
INSERT INTO items VALUES ("coke", 100);
SELECT * FROM items;
name	price
discount	-10
coke	100
hamburger	120
SELECT * FROM items WHERE price <= 100;
name	price
discount	-10
coke	100
DROP TABLE items;
