Greetinsg... When I am doing
show index from db.tablename, the columns I am gettings are - Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment Which one of these will tell me whether a key is fulltext or not. Rgds Ritesh SQLyog ( http://www.webyog.com ) The Definative GUI for MySQL ----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Insanely Great" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, October 01, 2002 7:16 PM Subject: Re: How to find whether a key is fulltext > At 18:19 +0530 10/1/02, Insanely Great wrote: > >Greetings.. > > > >I am doing show keys from db.tablename but how can I know whether the key if > >fulltext or not. I get to know the key is unique or not by checking > >Not_Unique column in the returned resultset. > > SHOW KEYS shows this information in the Index_type column. > > > > >How to find a key is fulltext. > > > >Thx > >Insane > > > >sql,query,mysql > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
