Wednesday, December 2, 2009

mysql :: tab to autocomplete table names

If you use mysql client, and the table names are quite lengthy to type, you can enable mysql's auto-rehash option to use the auto-complete feature. This is similar to how one would use tab key for auto-completion in command prompt.

When invoking mysql client, issue auto-rehash option as below -
mysql -u uname -p --auto-rehash
However, do note that the mysql client will startup slowly as it requires to create the hash on the table names etc.

No comments: