drop tables fruit, inventory
Sending Query... create table fruit (fruitID TINYINT UNSIGNED not null primary key auto_increment, name varchar(8), price double(5,2) )
Sending Query... insert into fruit Values( 1, "apple", 2.5), (2, "pear", 3.0),(4, "Grpe", .75 ), (8, "pluot", 4.50 ), (6, "plum", 1.25 ),(3, "banana", 1.0 )
Sending Query... create table inventory (fruitID TINYINT UNSIGNED not null, quantity int )
Sending Query... insert into inventory values ( 1, 100 ), (3, 500 ), (2, 100 ), (1,250), (2,200 )