Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This IS WHAT THE OUTPUT SHOULD LOOK LIKE WHEN DONE CORRECTLY Why am I getting this error? Here the code for the table and INSERT

This IS WHAT THE OUTPUT SHOULD LOOK LIKE WHEN DONE CORRECTLYimage text in transcribed

Why am I getting this error? Here the code for the table and INSERT INTO for table values

14:28:20 INSERT INTO location values( 1,'Independence Hall',794.35,651.43) Error Code: 1136. Column count doesn't match value count at row 1 0.000 sec

image text in transcribedimage text in transcribed

54 - INSERT INTO Photograph values (1,2,1),(2,4,1),(3,6,3),(4,8,4); 55 select * from photograph; CREATE TABLE users ( userid INTEGER NOT NULL PRIMARY KEY UNIQUE AUTO_INCREMENT, name VARCHAR(50), username VARCHAR(20), address VARCHAR(50), city VARCHAR(20), state VARCHAR (2), zip INTEGER(5), password VARCHAR(20) ); CREATE TABLE location ( itemid INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, type INTEGER, description VARCHAR(50), Ing REAL, lat REAL )j CREATE TABLE photograph ( photoid INTEGER, locationid INTEGER ) IS M, sol. Workbanch * Locs instarce tospau0

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

Hands On Database

Authors: Steve Conger

1st Edition

013610827X, 978-0136108276

More Books

Students also viewed these Databases questions

Question

What is the difference between absolute and relative pay?

Answered: 1 week ago

Question

Define the term Working Capital Gap.

Answered: 1 week ago

Question

Advance warning and an explanation for the layoff.

Answered: 1 week ago