search

webyog / sqlyog-community

Webyog provides monitoring and management tools for open source relational databases. We develop easy-to-use MySQL client tools for performance tuning and database management. Webyog's solutions include SQL Diagnostic Manager for MySQL performance optimization and SQLyog for MySQL administration. More than 35,000 companies (including Amazon, IBM, Salesforce, AT&T, eBay, and GE) and 2.5 million users rely on Webyog's solutions to provide valuable insights into their databases. Webyog is an Idera, Inc. company.
https://webyog.com/
GNU General Public License v2.0
2.18k stars 323 forks source link

Index Types In Pull-Down Menu #1845

Open atulwy opened 9 years ago

atulwy commented 9 years ago

Original issue 1845 created by webyog on 2012-08-10T05:57:51.000Z:

User reported in our forum:

"1. When CREATING an index, the pull-down menu gives a choice between UNIQUE, FULLTEXT and PRIMARY. --> First, a digression: I am curious about why the FULLTEXT option is shown, as the mySQL documentation says it only works with MyISAM. --> But that's not my main question. At this stage, SQLyog ALLOWS me to select NO option for the index. Great.

  1. In the next step, when ALTERING an index, if it's a UNIQUE or PRIMARY index, the pull-down menu gives no option for the "no option" index that was offered in step 1. The pull-down menu again offers UNIQUE, PRIMARY or FULLTEXT, but not "regular". So if I want to go from a UNIQUE index to a regular index, I have to destroy the index and create it again."

Refer: http://www.webyog.com/forums/index.php?showtopic=6676

atulwy commented 9 years ago

Comment #1 originally posted by webyog on 2012-09-10T11:28:36.000Z:

FULLTEXT is an option with recent InnoDB versions as well (not sure if it is 5.5 or 5.6).

atulwy commented 9 years ago

Comment #2 originally posted by webyog on 2012-10-12T10:10:30.000Z:

atulwy commented 9 years ago

Comment #3 originally posted by webyog on 2012-10-19T06:14:38.000Z:

<empty>

atulwy commented 9 years ago

Comment #4 originally posted by webyog on 2014-03-03T23:30:20.000Z:

This is quite troublesome. You can't really add an standard index from what I can tell...Unless this is indexing the blank value as a standard index.