Link to home
Create AccountLog in
Avatar of andieje
andieje

asked on

mysql shortcuts

Hello

Is there a mysql shortcut equivalent to the tab key in *nix which will tab through the available database or table names as appropriate to the context of the msql statement you are writing?

thanks
ASKER CERTIFIED SOLUTION
Avatar of woolmilkporc
woolmilkporc
Flag of Germany image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
If it's not enabled by default try

mysql --auto-rehash ... ...

Note: you must have accessed a database, either with the invocation parameter of mysql or with a "use database" statement to make this feature work.
Avatar of andieje
andieje

ASKER

i'm on a windows machine at the moment (you may recall i've been having problems with my mysql installation on linux to put it mildly)

i don't think it works on windows? where was i supposed to type --auto-rehash: i tried it as a flag during connection and typed it directly at the mysql command prompt once connected. i didn't get an error in either instance but it doesn't work.
Well,

I suspect that it won't work with the Windows client! Anyway, try this:

Once you started mysql and connected to a DB type "rehash" (without any "-" signs) and hit <Enter>.

Now try it out. If it still doesn't work I'm afraid we're lost!

wmp

 
mysql --help
or just
help
inside the commandline tool
should show you all available options/flags.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of andieje

ASKER

arnold, i've installed mysql workbench and read through the relevant chapters of the manual and i don't see how you can create queries 'graphically' in the same way as you can in say access by dragging tables and ticking fields to be included in the query. Am i missing something?
I am not sure that mysql tools have a query designer type of setup as MS SQL/Oracle.
I have not have at my finger tips the newer workbench with mysql query browser to check it out. But according to the link http://dev.mysql.com/doc/query-browser/en/mysql-query-browser-using-graphicalbuilding.html the newer version do have that capability.

toad for mysql does have a query builder where you add the tables, check the columns of interest to you and it creates the query.
http://www.quest.com/toad-for-mysql/
Avatar of andieje

ASKER

thanks