Answered: his IS WHAT THE OUTPUT SHOULD LOOK LIKE…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

This 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 )

Expert Solution

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions