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 theHow 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!