Capitalize Input via Auto Complete?

I am new to MySQL coming from PostgreSQL & noticed a really annoying
issue. When I select a database, and try to auto complete in MySQL, it
doesn't capitalize the MySQL statements.

It's irritating to me to only be able to auto complete statements like
'SELECT', 'ALTER', & 'INSERT' only if I hold down the shift key or
caps lock key while typing. Is there a way to force MySQL to auto
complete commonly used statements while typing them in lowercase which
is normal behavior in PostgreSQL?

Thanks for any info!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Capitalize Input via Auto Complete?

Get this tool: http://sqlyog.com/ it rocks.

There is also http://www.quest.com/toad-for-mysql/ which is pretty great.

> -----Original Message-----
> From: Carlos Mennens [mailto:carloswill@gmail.com]
> Sent: Tuesday, September 14, 2010 9:03 AM
> To: MySQL
> Subject: Capitalize Input via Auto Complete?
>
> I am new to MySQL coming from PostgreSQL & noticed a really annoying
> issue. When I select a database, and try to auto complete in MySQL, it
> doesn't capitalize the MySQL statements.
>
> It's irritating to me to only be able to auto complete statements like
> 'SELECT', 'ALTER', & 'INSERT' only if I hold down the shift key or
> caps lock key while typing. Is there a way to force MySQL to auto
> complete commonly used statements while typing them in lowercase which
> is normal behavior in PostgreSQL?
>
> Thanks for any info!
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=daevid@daevid.com
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Capitalize Input via Auto Complete?

Daevid Vincent wrote:
> Get this tool: http://sqlyog.com/ it rocks.
>
> There is also http://www.quest.com/toad-for-mysql/ which is pretty great.
>
>
Alternatively, there is MySQL WorkBench. Some of the guys around here
use SQLYog but, since it is a LAMP environment, I like that WorkBench is
native instead of dealing with wonky Wine issues. I haven't noticed
anything that I miss from SQLYog yet.
>> -----Original Message-----
>> From: Carlos Mennens [mailto:carloswill@gmail.com]
>> Sent: Tuesday, September 14, 2010 9:03 AM
>> To: MySQL
>> Subject: Capitalize Input via Auto Complete?
>>
>> I am new to MySQL coming from PostgreSQL & noticed a really annoying
>> issue. When I select a database, and try to auto complete in MySQL, it
>> doesn't capitalize the MySQL statements.
>>
>> It's irritating to me to only be able to auto complete statements like
>> 'SELECT', 'ALTER', & 'INSERT' only if I hold down the shift key or
>> caps lock key while typing. Is there a way to force MySQL to auto
>> complete commonly used statements while typing them in lowercase which
>> is normal behavior in PostgreSQL?
>>
>> Thanks for any info!
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=daevid@daevid.com
>>
>>
>
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Capitalize Input via Auto Complete?

On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent wrote:
> Get this tool: http://sqlyog.com/ it rocks.
>
> There is also http://www.quest.com/toad-for-mysql/ which is pretty great.

I can't use any graphical or 3rd party add-on's. I was hoping MySQL
had this native / built in. I guess not...

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Capitalize Input via Auto Complete?

--------------050505060304040607080708
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Carlos Mennens wrote:
> On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent wrote:
>> Get this tool: http://sqlyog.com/ it rocks.
>>
>> There is also http://www.quest.com/toad-for-mysql/ which is pretty great.
>
> I can't use any graphical or 3rd party add-on's. I was hoping MySQL
> had this native / built in. I guess not...
>
There's some impressive stuff built for VIM, but my VIM-fu is still
pretty weak. This is script, though. [
http://www.vim.org/scripts/script.php?script_id=356 ]

--------------050505060304040607080708--

Re: Capitalize Input via Auto Complete?

On Tue, 2010-09-14 at 15:45 -0400, george larson wrote:
> Daevid Vincent wrote:
> > Get this tool: http://sqlyog.com/ it rocks.
> >
> > There is also http://www.quest.com/toad-for-mysql/ which is pretty great.
> >
> >
> Alternatively, there is MySQL WorkBench. Some of the guys around here
> use SQLYog but, since it is a LAMP environment, I like that WorkBench is
> native instead of dealing with wonky Wine issues. I haven't noticed
> anything that I miss from SQLYog yet.

I've been using sqlyog on wine for a while now, with no issues. it has
never crashed, or caused errors in anyway. I am on Ubuntu 9.10 (it
wants to uninstall wine to upgrade to 10.04, so for now i am not
upgrading)

Steve

> >> -----Original Message-----
> >> From: Carlos Mennens [mailto:carloswill@gmail.com]
> >> Sent: Tuesday, September 14, 2010 9:03 AM
> >> To: MySQL
> >> Subject: Capitalize Input via Auto Complete?
> >>
> >> I am new to MySQL coming from PostgreSQL & noticed a really annoying
> >> issue. When I select a database, and try to auto complete in MySQL, it
> >> doesn't capitalize the MySQL statements.
> >>
> >> It's irritating to me to only be able to auto complete statements like
> >> 'SELECT', 'ALTER', & 'INSERT' only if I hold down the shift key or
> >> caps lock key while typing. Is there a way to force MySQL to auto
> >> complete commonly used statements while typing them in lowercase which
> >> is normal behavior in PostgreSQL?
> >>
> >> Thanks for any info!
> >>
> >> --
> >> MySQL General Mailing List
> >> For list archives: http://lists.mysql.com/mysql
> >> To unsubscribe:
> >> http://lists.mysql.com/mysql?unsub=daevid@daevid.com
> >>
> >>
> >
> >
>



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: Capitalize Input via Auto Complete?

> -----Original Message-----
> From: Carlos Mennens [mailto:carloswill@gmail.com]
> Sent: Tuesday, September 14, 2010 12:54 PM
> To: MySQL
> Subject: Re: Capitalize Input via Auto Complete?
>
> On Tue, Sep 14, 2010 at 2:24 PM, Daevid Vincent
> wrote:
> > Get this tool: http://sqlyog.com/ it rocks.
> >
> > There is also http://www.quest.com/toad-for-mysql/ which is
> pretty great.
>
> I can't use any graphical or 3rd party add-on's. I was hoping MySQL
> had this native / built in. I guess not...

Is there some reason you can't use a graphical tool?

You do know you can use ssh tunnels and such to connect to your server from
your desktop right? I do it all day long. It's pretty easy to do and built
in to these programs.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Capitalize Input via Auto Complete?

--000e0cd4c8d84bde7d04904b91e7
Content-Type: text/plain; charset=ISO-8859-1

On Wed, Sep 15, 2010 at 12:50 AM, Daevid Vincent wrote:

> You do know you can use ssh tunnels and such to connect to your server from
> your desktop right? I do it all day long. It's pretty easy to do and built
> in to these programs.
>

You can't multi-jump, though. Yes, that's common in my environment :-)


--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--000e0cd4c8d84bde7d04904b91e7--

Re: Capitalize Input via Auto Complete?

Johan De Meersman wrote:
> On Wed, Sep 15, 2010 at 12:50 AM, Daevid Vincent wrote:
>
>> You do know you can use ssh tunnels and such to connect to your server from
>> your desktop right? I do it all day long. It's pretty easy to do and built
>> in to these programs.
>>
>
> You can't multi-jump, though. Yes, that's common in my environment :-)
>
What do you mean by multi-jump?

I commonly set up a tunnel to the SSH server at the office and then
another tunnel from that server to my development rig, so I can run
MySQL WB at home on my database at work. Is that what you mean?


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Capitalize Input via Auto Complete?

--00504501400cd4432a04904c9b8d
Content-Type: text/plain; charset=ISO-8859-1

On Wed, Sep 15, 2010 at 3:39 PM, george larson wrote:

> I commonly set up a tunnel to the SSH server at the office and then
> another tunnel from that server to my development rig, so I can run
> MySQL WB at home on my database at work. Is that what you mean?
>

Pretty much, yeah. I've not got just the one database, though, so it's
usually too much of a bother to set up all the tunnels, and I just SSH
straight through and use the commandline :-)

Still, the SSH tunnel capability in the client is nice for hosts that are
only one jump away.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--00504501400cd4432a04904c9b8d--

Re: Capitalize Input via Auto Complete?

On Wed, Sep 15, 2010 at 6:50 AM, Johan De Meersman wro=
te:
>
>> I commonly set up a tunnel to the SSH server at the office and then
>> another tunnel from that server to my development rig, so I can run
>> MySQL WB at home on my database at work. =A0Is that what you mean?
>>
>
> Pretty much, yeah. I've not got just the one database, though, so it's
> usually too much of a bother to set up all the tunnels, and I just SSH
> straight through and use the commandline :-)
>
> Still, the SSH tunnel capability in the client is nice for hosts that are
> only one jump away.

It works for multiple jumps too. You just have to enable X11
forwarding either in the appropriate config files or do it on the
commandline. Note that it's possible that a severely paranoid
sysadmin may well have disabled it in the sshd service on one or more
of the machines that you're ssh'ing to.

# my workstation has ForwardX11=3Dyes in ~/.ssh/config
ssh host1

# then from there:
ssh -X host2

On host 2, running a gui app pops it up on my local desktop.
--=20
Regards...=A0 =A0 =A0 Todd
I seek the truth...it is only persistence in self-delusion and
ignorance that does harm.=A0 -- Marcus Aurealius

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Capitalize Input via Auto Complete?

--001636cd730adb16e50490720128
Content-Type: text/plain; charset=ISO-8859-1

On Thu, Sep 16, 2010 at 2:35 PM, Todd Lyons wrote:

> On Wed, Sep 15, 2010 at 6:50 AM, Johan De Meersman
> wrote:
> >
> >> I commonly set up a tunnel to the SSH server at the office and then
> >> another tunnel from that server to my development rig, so I can run
> >> MySQL WB at home on my database at work. Is that what you mean?
> >>
> >
> > Pretty much, yeah. I've not got just the one database, though, so it's
> > usually too much of a bother to set up all the tunnels, and I just SSH
> > straight through and use the commandline :-)
> >
> > Still, the SSH tunnel capability in the client is nice for hosts that are
> > only one jump away.
>
> It works for multiple jumps too. You just have to enable X11
> forwarding either in the appropriate config files or do it on the
> commandline. Note that it's possible that a severely paranoid
> sysadmin may well have disabled it in the sshd service on one or more
> of the machines that you're ssh'ing to.
>
> # my workstation has ForwardX11=yes in ~/.ssh/config
> ssh host1
>
> # then from there:
> ssh -X host2
>
> On host 2, running a gui app pops it up on my local desktop.
>

You misunderstand me :-) I specified "in the client", referring to the
Workbench app, not the SSH client.

ssh-level jumps have always been possible, and work with whatever too you
want them to. The convenience of the Workbench-integrated jump, is that I
don't have to bother setting up the tunnel manually, remember what
particular host I tied to what particular local IP/port combo, et cetera.

I've not just the one server to admin, you know - I just ordered 20 licenses
for ZRM backup, to cover the most important machines. The rest of them
aren't important enough to warrant that cost, they'll manage fine with a
nightly dump.

So, as I said; I use workbench (occasionally) for hosts that are 0 or 1 jump
away; for the rest I just go there through plain SSH and do stuff
commandline.





> --
> Regards... Todd
> I seek the truth...it is only persistence in self-delusion and
> ignorance that does harm. -- Marcus Aurealius
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=vegivamp@tuxera.be
>
>


--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--001636cd730adb16e50490720128--