help with phpmyadmin

[Matthew Robinson]

i tried to create a new table using phpmyadmin, but it gave me an error -
can anybody see what the problem is, and the correct code i could put into
the SQL section (kind of like the mysql command line, but in a php page).
TIA.

SQL-query :

CREATE TABLE `faq` (
`id` INT( 10 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
`question` LONGBLOB( 1000 ) DEFAULT 'question' NOT NULL ,
`answer` LONGBLOB( 5000 ) DEFAULT 'answer' NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE (
`question`
)
) COMMENT = 'table of frequently asked questions for FAQ page'

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'(1000) DEFAULT 'question' NOT NULL, `answer` LONGBLOB(5000) DEF

[martin]

Matthew Robinson <ma*************@hotmail.com> wrote in message news:<pa***************************@hotmail.com>.. .

i tried to create a new table using phpmyadmin, but it gave me an error -
can anybody see what the problem is, and the correct code i could put into
the SQL section (kind of like the mysql command line, but in a php page).
TIA.

SQL-query :

CREATE TABLE `faq` (
`id` INT( 10 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
`question` LONGBLOB( 1000 ) DEFAULT 'question' NOT NULL ,
`answer` LONGBLOB( 5000 ) DEFAULT 'answer' NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE (
`question`
)
) COMMENT = 'table of frequently asked questions for FAQ page'

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'(1000) DEFAULT 'question' NOT NULL, `answer` LONGBLOB(5000) DEF

MySQL bitfield data types don't take size
or allow default value specifications.
Like:
`question` LONGBLOB NOT NULL ,
`answer` LONGBLOB NOT NULL ,

[Peter Taurins]

From memory, don't put a length attribute on a LONGBLOB.

Peter.
"Matthew Robinson" <ma*************@hotmail.com> wrote in message
news:pa***************************@hotmail.com...

i tried to create a new table using phpmyadmin, but it gave me an error -
can anybody see what the problem is, and the correct code i could put into
the SQL section (kind of like the mysql command line, but in a php page).
TIA.

SQL-query :

CREATE TABLE `faq` (
`id` INT( 10 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
`question` LONGBLOB( 1000 ) DEFAULT 'question' NOT NULL ,
`answer` LONGBLOB( 5000 ) DEFAULT 'answer' NOT NULL ,
PRIMARY KEY ( `id` ) ,
UNIQUE (
`question`
)
) COMMENT = 'table of frequently asked questions for FAQ page'

MySQL said:

#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'(1000) DEFAULT 'question' NOT NULL, `answer` LONGBLOB(5000) DEF