Gossamer Forum
(Advanced Search)
for
Home : General : Perl Programming :

SQL Query..

Nov 21, 2001, 8:10 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Nov 21, 2001, 8:10 AM
Post #1 of 4
Views: 3819
Shortcut
Quote Reply
SQL Query..
Anyone got any idea why my SQL query isz not working? I have spent the last hour staring at it, but it still wont work Frown

It is;

Code:
CREATE TABLE `guestbook_table` (
`newID` SMALLINT(5) NOT NULL AUTO_INCREMENT,
`personname` TEXT(255) NOT NULL,
`comment` TEXT(255) NOT NULL,
`email` TEXT(255) NOT NULL,
`adddate` DATE(255) NOT NULL)

Thanks

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Nov 21, 2001, 8:28 AM
Paul
Veteran (19537 posts)
Nov 21, 2001, 8:28 AM
Post #2 of 4
Views: 3622
Shortcut
Quote Reply
Re: [AndyNewby] SQL Query.. In reply to
Probably because newID has to be specified as a primary key.
Nov 21, 2001, 8:47 AM
Wil
Veteran / Moderator (4108 posts)
Nov 21, 2001, 8:47 AM
Post #3 of 4
Views: 3614
Shortcut
Quote Reply
Re: [AndyNewby] SQL Query.. In reply to
You can not specify a colum length for a TEXT column therefore all of your TEXT(255) statements will produce an error.

Cheers

- wil
Nov 21, 2001, 8:50 AM
Stealth
Veteran (17240 posts)
Stealth's avatar
Nov 21, 2001, 8:50 AM
Post #4 of 4
Views: 3603
Shortcut
Quote Reply
Re: [AndyNewby] SQL Query.. In reply to
If you want to vary the maximum length of characters in "text" based columns, you should use either "VARCHAR" or "CHAR", then you can use (number) to specify a max length.

Also, you should always use INT for primary keys in tables, NOT SMALLINT, and as Paul mentioned, that field should be PRIMARY.
========================================
Buh Bye!

Cheers,
Me