yourfirstserver.comThursday, 24 May 2012
Find Us on : RSS/Feed Facebook Twitter

5 Useful Mysql Command Options-Pager-Prompt-Rehash-Tee-System

There are set of commands that MySQL itself interprets. You may use “help” or “\h” at the mysql> prompt to list them.

Below are the 5 most useful MySQL Command Options.

1. \# OR rehash: Enable automatic rehashing.

Do you have long table names, you find it difficult to remember tablenames or you’re just as lazy as I am, rehashing is good for you.
Enter:
mysql> \#
or
mysql> rehash
This enables database, table, and column name completion.
To complete a name, enter the initial part of name and

...