Member Avatar for Gl753

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
  • 260 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by Dani
Member Avatar for Gl753

Never mind, I just realised I was missing a comma

Member Avatar for Dani

MOVIE_TITLE VARCHAR(30) NOT NULL,. <= you seem to have a period after this line

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.