Peter van Schie wrote:
> starman7@hotmail.com wrote:
>
> > Could I create a view in my tablespace of the columns/tables,etc. I
> > need from the db where I have limited privs, and create the fulltext
> > index from this view? Otherwise I could manually populate a special
> > table in my tablespace with dumps from the ltd. db, but this would be
> > more work (and requiring regular updating) than I'd like.
>
> It'll only work if the table containing the text columns is of type
> MyISAM. I don't really understand why you want to use a view here though.
>
> > Can I fulltext index several columns?
>
> Yes.

Thanks for the responses,

>
> > Is it common to do fulltext indexing on a derived, view, or specially
> > created for this purpose -table?
>
> Sometimes fulltext columns are seperated from other (InnoDB) tables and
> moved into a seperate MyISAM table, just because fulltext search is
> needed on a certain column(s).
>
> Peter.

I suppose it boils down to: I don't have alter, update, or create
permissions on the DB tables I need to fulltext index, though I can
select on this DB, and I do have full perms on my own DB, how can I
create an entity that I can fulltext index, to later search, based on a
DB/tables I can only select on.

I thought maybe create a view in my DB of the specific columns I need,
from the tables in the other DB (is that even possible to do?).

The tables I need to fulltext index are innodb ...

is it possible for a view to be used to fulltext index on? e.g .does
the process by which a fulltext index is created, work on a view? what
if the columns composing the view come from innodb tables? can a view
be created from columns where the original tables are both innodb and
myisam?

maybe i will just have to populate a myisam table in my DB from a query
that has all the info/columns I need to fulltext index?


Thanks again for any hints,
s7
>
> --
> http://www.phpforums.nl