新增暫存表

CREATE TEMPORARY TABLE order (

item_name VARCHAR(50) NOT NULL,

price DECIMAL(7,2) NOT NULL DEFAULT 0.00,

quantity INT UNSIGNED NOT NULL DEFAULT 0

);

DROP TABLE order;