At 20:36 -0800 11/5/02, Phil Straw wrote:
OK guys, I am a relative newbie with MySql, but know something at least of
databases. Please can you direct me as to where this CREATE statement is
wrong. I am lost.
I get ERRORCODE 1064 which looks to be near DB_ERROR_SYNTAX in the code.
Before wading through all that I though I might ask the experts....
create table test.Links (
url TEXT NOT NULL,
safe SMALLINT NOT NULL,
broken TINYINT,
summary VARCHAR NOT NULL,
VARCHAR isn't legal without a length, e.g., VARCHAR(20).
details TEXT,
averating SMALLINT,
addedbyuser VARCHAR NOT NULL,
urlhash CHAR NOT NULL PRIMARY KEY
)
Followed by
SQLSTATE 42000
ERRORCODE 1064
MESSAGE:
Syntax error or access violation: You have an error in your SQL syntax
near 'NOT NULL,
details TEXT,
averating SMALLINT,
addedbyuser VARCHAR NOT NULL,
' at line 5
Any help welcome !
P/.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
