Good evening List,
I have a problem on my fulltext-search. If I create the sample table from
MySQL-Doc it runs perfect.
If I create my own - it doesn't. I can't say more: Here is my dump:
CREATE TABLE tcl (id int(10) primary key not null, description varchar(254),
date timestamp, value int(11),
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))
- Original Message -
From: Jan Peuker [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 02, 2002 10:24 AM
Subject: FullText Search 3.23.49-nt
Good evening List,
I have a problem on my fulltext-search. If I create the sample table from
MySQL-Doc it runs perfect.
If I create