Re: Err 1191 Can't find FULLTEXT .. need explanation please
Posted by:
Rick James
Date: October 20, 2011 05:14AM
No advantage in having duplicate indexes:
FULLTEXT KEY `name_of_index` (`pagetitle`,`longtitle`,`content`),
FULLTEXT KEY `pagetitle` (`pagetitle`,`longtitle`,`content`),
FULLTEXT KEY `pagetitle_2` (`pagetitle`,`longtitle`,`content`)
and a disadvantage: disk space.
> `deletedon` int(20) NOT NULL DEFAULT '0',
What are you hoping to put into that field? An INT can hold no more than 2 billion. Maybe you need BIGINT?
Indexing flags is usually useless:
> `uri_override` tinyint(1) NOT NULL DEFAULT '0',
> KEY `uri_override` (`uri_override`),
You may find that 255 is inadequate:
`pagetitle` varchar(255) NOT NULL DEFAULT '',
`longtitle` varchar(255) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '',
> I would like to know WHY ...
A SHOW CREATE TABLE _between_ the ALTER and the 'click' might a good clue.
Subject
Views
Written By
Posted
7814
October 19, 2011 02:44AM
Re: Err 1191 Can't find FULLTEXT .. need explanation please
2610
October 20, 2011 05:14AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.