Is there a MySQL terminal prompt that supports things like tab-completion and history? The standard one that comes with MySQL doesn't have those features
I can only speak from Linux experience, but the MySQL command line tool is chock full of options, including the two that you mention.
Tab completion is as simple as pressing the Tab key to expand database, table, and column names. From the MySQL docs:
Tab completion is enabled by default, however, it can be turned off by adding
As far as history... MySQL saves every query you execute in $MYSQL_HISTFILE, which defaults to ~/.mysql_history. Simply, pressing the Up and Down arrows will scroll through your history. If you want more advanced searching, mysql is compiled with the GNU readline library so all you need to do is type
For more information check out: