CREATE TEMPORARY TABLE Products( product_name VARCHAR(50) NOT NULL, total_sales DECIMAL(12,2) NOT NULL DEFAULT 0.00, avg_unit_price DECIMAL(7,2) NOT NULL DEFAULT 0.00, total_units_sold INT UNSIGNED NOT NULL DEFAULT 0);
INSERT INTO Products (product_name, total_sales, avg_unit_price, total_units_sold) VALUES ('product',1000.25,900,200);
SELECT * FROM SalesSummary;
DROP TABLE SalesSummary;
edit | flag
Gokul A Answered on: Dec 10, 2011 at 12:34AM
Post your Answer
Welcome to Ask Amoeba! This is 100% free and interactive site for sharing professional Questions and Answers, Opensource projects, Interview questions. Learners, beginners, Experts stop and share your knowledge and ideas!