> Try not using the word 'text' as your column name. Using reserved and key
> words causes problems.
> Chris
sql
> >>CREATE TABLE tcl (id int(10) primary key not null, description
> varchar(254), date timestamp, value int(11), department tinyint(3), text
> text, fulltext(description,text))
>
---------------------------------------------------------------------
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