Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2004
    Posts
    74

    Unanswered: howto get existing index name ?

    hi, have a problem to get the existing indexes from DB, i use the following code to set the index ..but how i do get it back all indexes which have set?

    Code:
    alter table mytable add index myindex (state,country);
    anyone can guide ? thank you

  2. #2
    Join Date
    Feb 2004
    Posts
    533
    DESC tbl_name

    DESCRIBE Statement
    Source : mySQL documentation
    */
    { DESCRIBE | DESC } tbl_name {col_name | wild}




    /
    ~

    Bill

  3. #3
    Join Date
    Mar 2004
    Posts
    74
    savbill , Desc table on five the column info..but what if i wan to get what are the index name which have set by user in table ...thank you for your reply

  4. #4
    Join Date
    Mar 2004
    Posts
    74
    savbill , 'Desc table' use to describe the column info..but what if i wan to get what are the index name which have set by user in table ...thank you for your reply

  5. #5
    Join Date
    Dec 2004
    Posts
    26
    SHOW INDEX FROM table;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •