CREATE TABLE IF NOT EXISTS flatpackstuff (
FLATPACKID int AUTO_INCREMENT, NAME varchar (20) NOT NULL, COLOUR varchar (20), TYPE ENUM ("Office", "Kitchen", "Bedroom", "General"), UNITPRICE decimal CHECK (UNITPRICE BETWEEN 5.00 and 500.00) PRIMARY KEY (FLATPACKID));
I am trying to ensure that UNITPRICE is between 5.00 and 500.00 but I am getting errors.
A comma or closing bracket was expected near CHECK
Unexpected beginning of a statement near UNITPRICE
Unrecognised statement type (near BETWEEN)
Where am I going wrong