What's wrong with this?

Posted: Sun Dec 29, 2002 9:09 pm (21 years, 12 months ago)

Hi,

I am very new to using Mysql and am just experimenting, but when I ran this it came back with an error in my syntax, can anyone spot why?

Code:

CREATE TABLE links (
link_id INT IDENTITY (1,1) NOT NULL,
url VARCHAR (225) NOT NULL,
url_name VARCHAR (225) NOT NULL,
mini_review VARCHAR (400) NULL,
big_review BIT NOT NULL,
url_review VARCHAR (225) NULL,
rating CHAR (10) NOT NULL,
);

Thanks

Posted: Sun Dec 29, 2002 10:21 pm (21 years, 12 months ago)

Ok, don't worry, I realised that that was verryyy wrong and have corrected it myself and it now works!

Anyway, for the mini_review, what data type would you recommend using for something to hold upto 400 characters?

And what would be best to use when I only want 0 or 1 in it?