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 AUTOINCREMENT,
title VARCHAR
genre VARCHAR
releaseyear INT,
director VARCHAR
studio VARCHAR
criticsrating DECIMAL DEFAULT
;
manually get help for
caret position or
automatic h
Alter tABLE moviesbasic ADD COLUMn boxofficegross FLOAT;
ALtER TABLE moviesbasic RENAME COLUMN criticsrating to criticrating;
Action Output
:: ALTER TABLE moviesbasic ADD COLUMN boxofficegross FLOAT rows affected Records: Duplicates: Wamings:
:: ALTER TABLE moviesbasic RENAME COLUMN criticsrating TO criticrat... Error Code: You have an error in your SQL syntax; check the manual t
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
