Question: How do i fix these two codes to properly go into the tables ? In my sql Workbench Query because the tables are made but
How do i fix these two codes to properly go into the tables ? In my sql Workbench Query because the tables are made but the values im trying to enter come up as null and null.
CREATE TABLE ITEMID ( ItemName int (11) auto_increment, ItemID varchar(20), PRIMARY KEY (ItemName) ) auto increment-1: INSERT NTO ITEMID (ItemID, Item Name) VALUES (null, 'Pencil'), (null, 'Binder'), (null, 'Pencil'), (null, 'Binder'); SELECT * FROM ITEMID CREATE TABLE INVOICE!D ( InvoiceDate int(11) auto_increment, InvoiceID varchar(20), PRIMARY KEY (InvoiceDate) auto increment-1: INSERT INTO NVOICE (InvoiceID, InvoiceDate) VALUES (null, '1/16/16'), (null, '1/23/16'), (null, '2/9/16'), (null, '2/26/16' ); SELECT * FROM INVOICE
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
