Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 INVOICEStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started