0

I'm working on a Database assigment but I'm kind of stuck. It seems to be the Double value that's causing the issue because when I use the Varchar data type I can create my table. Is there any way I can use Double without using Varchar.
Any help is much appreciated :)

CREATE TABLE MOVIE_INFO ( 
MOVIE_ID INT not null primary key
GENERATED ALWAYS AS IDENTITY
(START WITH 1, INCREMENT BY 1),  
MOVIE_TITLE VARCHAR(30) NOT NULL,.
ACTORS VARCHAR(40) NOT NULL,
CATAGORY VARCHAR(25) NOT NULL,
RELEASE_YEAR INT NOT NULL,
LANGUAGE_ VARCHAR (30) NOT NULL,
LENGTH_ VARCHAR (15) NOT NULL,
SPECIAL_FEATURES VARCHAR (6) NOT NULL,
AGE_RATING VARCHAR (8) NOT NULL,
MOVIE_RATING INT NOT NULL,
FORMAT_ VARCHAR (10) NOT NULL
DVD_RENTAL_COST DOUBLE ,
BLURAY_RENTAL_COST DOUBLE,
DVD_REPLACEMENT_COST DOUBLE,
BLURAY_REPALCEMENT_COST DOUBLE,
STOCK VARCHAR (20) NOT NULL
);
2
Contributors
2
Replies
11
Views
3 Years
Discussion Span
Last Post by Dani
0

Never mind, I just realised I was missing a comma

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.