|
Server IP : 172.16.15.8 / Your IP : 18.117.192.64 Web Server : Apache System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.2.24 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/bnhans/public_html/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
drop table Inventory;
create table Inventory
( item_name VARCHAR(30),
Purchase_cost INT,
Sale_Price INT,
Number_Sold INT,
Inventory INT );
insert into Inventory values ('Hammer', 5, 12, 122, 26);
insert into Inventory values ('Wrench', 2, 4, 9, 155);
insert into Inventory values ('Screwdriver', 3, 5, 55, 115);
insert into Inventory values ('Pliers', 2, 3, 26, 75);
insert into Inventory values ('Handsaw', 6, 9, 33, 93);