
use mytools;
DROP TABLE IF EXISTS item_desc;

CREATE TABLE item_desc (item_id INTEGER, item_desc VARCHAR(80), item_price DECIMAL(8,2));

INSERT INTO item_desc 
VALUES (100,'hammer', 20.00);

INSERT INTO item_desc 
VALUES (200,'screwdriver', 8.00);

INSERT INTO item_desc 
VALUES (100,'wrench', 10.00);

