[support] drush sql-query returns nothing

[Tim Johnson]

* Tim Johnson <tim at akwebsoft.com> [131104 11:30]:
> * Tim Johnson <tim at akwebsoft.com> [131104 10:53]:
> > I am using drush 5.8 on Mac OSX
> > 
> > drush sql-query returns nothing at all, can't see to get any
> > response whatsoever if I run (as example)
> > drush sql-query "show tables;" from sites/default
> > 
> > the only response I can get is if I run the command above from
> > above/outside the site root - and that is the "No database to
> > operate on." error..
> > 
> > could be a very handy feature of drush for me, but I'm clueless on
> > how to make it work and `drush help sql-query` doesn't provide me
> > with any clues as where to execute from...
>   Sorry, I should have included more of a demonstration of the issue
>   ..
>   from my user root :
> 
>   bash-3.2$ drush sql-query 'show table;'
>   No database to operate on.
> 
>   To be expected...
> 
>   from my site root - deliberate error
> 
>   /Users/http/sites/akwebsoft
>   bash-3.2$ drush sql-query 'show nothing;'
>   ERROR 1064 (42000) at line 1: You have an error in your SQL
>   syntax; check the manual that corresponds to your MySQL server
>   version for the right syntax to use near 'nothing' at line 1
> 
>   Also to be expected 
>   now a valid command :
> 
>   bash-3.2$ drush sql-query 'show tables;'
>   bash-3.2$
> 
>   Where's the output??
  Furthermore, if I invoke
  drush sqlc
  from the site root, I do get the MySQL cli for the site database,
  so I can assume that I am making the proper connection properly
  authenticated. 
-- 
Tim 
tim at tee jay forty nine dot com or akwebsoft dot com
http://www.akwebsoft.com, http://www.tj49.com