Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedHow 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Oracle 11G SQL

Authors: Joan Casteel

2nd Edition

1133947360, 978-1133947363

Students also viewed these Databases questions

Question

Pigouvian taxes always improve social welfare.

Answered: 1 week ago