4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 What's wrong with this?
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic
Author Message
billdavies
Senior WebHelper
Senior WebHelper


Joined: 22 Jan 2002
Posts: 107
Location: UK

PostPosted: Sun Dec 29, 2002 9:09 pm (14 years, 10 months ago) Reply with QuoteBack to Top

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
OfflineView User's ProfileFind all posts by billdaviesSend Personal MessageVisit Poster's WebsiteMSN Messenger
billdavies
Senior WebHelper
Senior WebHelper


Joined: 22 Jan 2002
Posts: 107
Location: UK

PostPosted: Sun Dec 29, 2002 10:21 pm (14 years, 10 months ago) Reply with QuoteBack to Top

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?
OfflineView User's ProfileFind all posts by billdaviesSend Personal MessageVisit Poster's WebsiteMSN Messenger
Display posts from previous:      
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic


 Jump to:   




You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.


Page generation time: 0.059575 seconds :: 17 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme