Need assistance with SQL assignment question:
Populate the CUST_NUM, INV_DATE, and INV_AMOUNT fields with the following customers:
CUST_NUM |
INV_DATE |
INV_AMOUNT |
|---|
1000 |
2016-03-23 |
235.89 |
1001 |
2016-03-23 |
312.82 |
1001 |
2016-03-30 |
528.10 |
1000 |
2016-04-12 |
194.78 |
1000 |
2016-04-23 |
619.44 |
Executed code below:
INSERT into invoice(cust_num, inv_date, inv_amount) values(1000, "2016-03-23", 235.89);
INSERT into invoice(cust_num, inv_date, inv_amount) values(1001, "2016-03-23", 312.82);
INSERT into invoice(cust_num, inv_date, inv_amount) values(1001, "2016-03-30", 528.10);
INSERT into invoice(cust_num, inv_date, inv_amount) values(1000, "2016-04-12", 194.78);
INSERT into invoice(cust_num, inv_date, inv_amount) values(1000, "2016-04-23", 619.44);
select * from invoice;
Receives error: ERROR 1146 (42S02) at line 1: Table 'Ch08_SimpleCo.invoice' doesn't exist