Question: 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 CORRECTLY
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


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
Get step-by-step solutions from verified subject matter experts
