DROP TABLE IF EXISTS items;
CREATE TABLE items (
name VARCHAR(255),
price INT UNSIGNED KEY
) DEFAULT CHARSET=utf8;
INSERT INTO items VALUES ("car", 4294967295);
INSERT INTO items VALUES ("note PC", 32767);
INSERT INTO items VALUES ("discount", 0);
INSERT INTO items VALUES ("coke", 100);
INSERT INTO items VALUES ("bike", 2147483648);
SELECT * FROM items;
name	price
discount	0
coke	100
note PC	32767
bike	2147483648
car	4294967295
SELECT * FROM items WHERE price <= 2147483648;
name	price
discount	0
coke	100
note PC	32767
bike	2147483648
SELECT * FROM items WHERE price > 2147483647;
name	price
bike	2147483648
car	4294967295
DROP TABLE items;
