act5, MySQL - rextester

act5

create table  Adamans (PID smallint auto_increment not null,
Product_Name varchar(100) not null,
Product_Category varchar(100) not null,
Manufacturer varchar(100) not null,
Unit_Price varchar(100) not null,
Unit_Sold varchar (1000) not null,
TOTAL_VALUE varchar (1000) not null,
primary key(PID));

Insert into Adamans(PID,Product_Name,Product_Category,Manufacturer,Unit_Price,Unit_Sold,TOTAL_VALUE)
Values ("1", "Surf Powder(Small) ","Bathroom Item", "Uniliver PH.", "7.00", "12 pcs", "84.00"),
("2", "Surf Powder(Big) 2kg ","Bathroom Item", "Uniliver PH.", "199.00", "2 pcs", "398.00"),
("3", "Surf Bar(Small) ","Bathroom Item", "Uniliver PH.", "6.00", "4 pcs", "24.00"),
("4", "Surf Bar(Jumbo) ","Bathroom Item", "Uniliver PH.", "10.00", "5 pcs", "50.00"),
("5", "Surf Bar(Long) ","Bathroom Item", "Uniliver PH.", "24.00", "2 pcs", "48.00"),

("6", "Mega Sardines(Green/Orig)","Kitchen Item", "Mega Global Corp.", "15.00", "2 pcs", "30 .00"),
("7", "Mega Sardines(Red/Spicy)","Kitchen Item", "Mega Global Corp.", "15.00", "4 pcs", "60.00"),

("8", "Magic sarap","Kitchen Item", "Universal Robina Corp", "13.00", "3 pcs", "39.00"),
("9", "Ginisa mix","Kitchen Item", "Universal Robina Corp.", "13.00", 
"6 pcs", "78.00"),
("10", "Wow","Kitchen Item", "Universal Robina Corp.", "13.00", "4 pcs", "52.00"),
("11", "Ajinomoto","Kitchen Item", "Universal Robina Corp.", "13.00", "4 pcs", "52.00"),
("12", "Sinigang Mix","Kitchen Item", "Universal Robina Corp.", "13.00", "3 pcs", "39.00"),

("13", "Skyflakes Pack(Condensada)","Biscuit Item", "Monde M.Y. San Corporation", "56.00", "2 pcs", "112.00"),
("14", "Skyflakes Pack(Mantikilya)","Biscuit Item", "Monde M.Y. San Corporation", "52.00", "3 pcs", "156.00"),
("15", "Skyflakes Pack(SweetMantikilya)","Biscuit Item", "Monde M.Y. San Corporation", "52.00", "3 pcs", "156.00"),
("16", "Skyflakes Pack(Assorted)","Biscuit Item", "Monde M.Y. San Corporation", "59.00", "1 pcs", "59.00"),
("17", "Skyflakes Pack(Orig)","Biscuit Item", "Monde M.Y. San Corporation", "56.00", "2 pcs", "112.00"),

("18", "Tayhee Noodles(Tri-color)","Kitchen Item", " TAIWAN TOBACCO & LIQUOR CORPORATION", "219.00", "1 pcs", "219.00"),
("19", "Tayhee Noodles(Sweet Potato)","Kitchen Item", "TAIWAN TOBACCO & LIQUOR CORPORATION", "219.00", "1 pcs", "219.00"),
("20", "Tayhee Noodles(Spinach)","Kitchen Item", "TAIWAN TOBACCO & LIQUOR CORPORATION", "219.00", "1 pcs", "219.00"),
("21", "Tayhee Noodles(Pumpkin)","Kitchen Item", "TAIWAN TOBACCO & LIQUOR CORPORATION", "219.00", "1 pcs", "219.00"),

("22", "Dove(White)","Bathroom Item", "Procter & Gamble", "8.00", "10 pcs", "80.00"),
("23", "Dove (Green)","Bathroom Item", "Procter & Gamble", "8.00", "5 pcs", "40.00"),
("24", "Dove (Blue)","Bathroom Item", "Procter & Gamble", "8.00", "5 pcs", "40.00"),
("25", "Dove (Pink)","Bathroom Item", "Procter & Gamble", "8.00", "5 pcs", "40.00"),
("26", "Dove (Black)","Bathroom Item", "Procter & Gamble", "8.00", "5 pcs", "40.00"),

("27", "Gardenia Bread(Tasty)","Kitchen Item", "Gardenia Bakeries Philippines Inc.", "55.00", "4 pcs", "220.00"),
("28", "Gardenia Bread(Wheat)","Kitchen Item", "Gardenia Bakeries Philippines Inc.", "75.00", "4 pcs", "500.00"),
("29", "Gardeni a Bread(WheatnRaisin)","Kitchen Item", "Gardenia Bakeries Philippines Inc.", "108.00", "3 pcs", "324.00"),
("30", "Gardenia Bread(Sandwich Loaf)","Kitchen Item", "Gardenia Bakeries Philippines Inc.", "62.00", "3 pcs", "186.00"),

("31", "Magic sarap","Kitchen Item", "Nestlé USA", "4.00", "12 pcs", "48.00"),
("32", "Ginisa mix","Kitchen Item", "Ajinomoto Philippine Corp", "3.00", "12 pcs", "36.00"),
("33", "Wow Sarap","Kitchen Item", "Silver Swan Manufacturing Co., Inc.", "2.00", "26 pcs", "56.00"),
("34", "Ajinomoto","Kitchen Item", "Ajinomoto Philippine Corp.", "13.00", "4 pcs", "52.00"),
("35", "Oyster Sause","Kitchen Item", "Mama Sita's Holding Company, Inc", "13.00", "3 pcs", "39.00");


run \| edit \| history \| help	0