Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Why is the last statement not working? Can you fix it ? id INT PRIMARY KEY NOT NULL AUTO _ INCREMENT, title VARCHAR ( 1

Why is the last statement not working? Can you fix it?
id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
title VARCHAR(100),
genre VARCHAR(20),
release_year INT,
director VARCHAR (40),
studio VARCHAR(30),
critics_rating DECIMAL (2,1) DEFAULT
;
manually get help for
caret position or
automatic h
Alter tABLE movies_basic ADD COLUMn box_office_gross FLOAT;
ALtER TABLE movies_basic RENAME COLUMN critics_rating to critic_rating;
Action Output
221:16:10 ALTER TABLE movies_basic ADD COLUMN box_office_gross FLOAT 0 row(s) affected Records: 0 Duplicates: 0 Wamings: 0
321:16:10 ALTER TABLE movies_basic RENAME COLUMN critics_rating TO critic_rat... Error Code: 1064. You have an error in your SQL syntax; check the manual t..
image text in transcribed

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

Databases Organizing Information Digital And Information Literacy

Authors: Greg Roza

1st Edition

1448805929, 978-1448805921

More Books

Students also viewed these Databases questions

Question

How could assessment be used in an employee development program?

Answered: 1 week ago