EVOLUTION-MANAGER

Edit File: column_signed_tinyint_with_index.result

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;