Jump to content

raymondrna

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Posts posted by raymondrna

  1. [code]

    show index from vinyl;
    ERROR 2006: MySQL server has gone away
    No connection. Trying to reconnect...
    Connection id:    2986025
    Current database: records

    +-------+------------+------------+--------------+-------------+-----------+-----                 --------+----------+--------+----------+
    | Table | Non_unique | Key_name   | Seq_in_index | Column_name | Collation | Card                 inality | Sub_part | Packed | Comment  |
    +-------+------------+------------+--------------+-------------+-----------+-----                 --------+----------+--------+----------+
    | vinyl |          0 | PRIMARY    |            1 | catalog     | A         |                            1 |     NULL | NULL   |          |
    | vinyl |          1 | full_index |            1 | label       | A         |                         NULL |     NULL | NULL   | FULLTEXT |
    | vinyl |          1 | full_index |            2 | title       | A         |                         NULL |     NULL | NULL   | FULLTEXT |
    | vinyl |          1 | full_index |            3 | composer    | A         |                         NULL |     NULL | NULL   | FULLTEXT |
    | vinyl |          1 | full_index |            4 | conducter   | A         |                         NULL |     NULL | NULL   | FULLTEXT |
    | vinyl |          1 | full_index |            5 | performer   | A         |                         NULL |     NULL | NULL   | FULLTEXT |
    +-------+------------+------------+--------------+-------------+-----------+-----                 --------+----------+--------+----------+
    6 rows in set (0.01 sec)

    mysql> select * from vinyl
        -> where match (title) against ('Symphony');
    ERROR:

    mysql>
    mysql> select * from vinyl
        -> where match (title) against ('Symphony');
    ERROR 2006: MySQL server has gone away
    No connection. Trying to reconnect...
    Connection id:    2986047
    Current database: records

    ERROR 1191: Can't find FULLTEXT index matching the column list
    mysql>
    [/code]

    what's going on?

    I ask mysql to describe the index and it tells me it's there. Do a match, and match tells me it's not?

    I'm guessing this is a simple syntax mistake, but I'm new with mysql and it seems like what I'm going should just work.

    :P

    Thanks for the help and your infinite wisdom!!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.