his IS WHAT THE OUTPUT SHOULD LOOK LIKE WHEN DONE CORRECTLY 54 - INSERT INTO Photograph values(1,2,1),(2,4,1),(3,6,3),(4,8,4);55∙select * from photograph; 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 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 )
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
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 )
Step by step
Solved in 2 steps with 1 images