Question: 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..
 Why is the last statement not working? Can you fix it?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!