MySQL ODBC Connector - MySQL Query Browser

Author

MySQL Query Browser

Scott Hamm

2005-09-29, 8:23 pm

------ =_Part_4591_24569851
.1128018878883
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

How do I run more than 1 queries in MySQL Query Browser?

--
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html

------ =_Part_4591_24569851
.1128018878883--

Rob Agar

2005-09-29, 8:23 pm

hi Scott

> How do I run more than 1 queries in MySQL Query Browser?

The only way I've found is to put the queries in a .sql file and load it
via File > Open Script. It doesn't accept multiple typed in queries,
even if they are separated by semicolons.

hth
Rob

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

SGreen@unimin.com

2005-09-30, 9:23 am

--=_alternative 004B12808525708C_=
Content-Type: text/plain; charset="US-ASCII"

"Rob Agar" <rob@wildlime.com> wrote on 09/29/2005 08:27:37 PM:

> hi Scott
>
>
> The only way I've found is to put the queries in a .sql file and load it
> via File > Open Script. It doesn't accept multiple typed in queries,
> even if they are separated by semicolons.
>
> hth
> Rob
>
>
>
He can just start a new script tab, can't he? That's how I do it. I don't
know why they have two different types of tabs (one for multi-statements
and one for single statements) but they do.

File -> New Script Tab

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 004B12808525708C_=--

Sujay Koduri

2005-09-30, 9:23 am

I am not saying MysQL Query Browser is anyway bad or inferior, but as for my
experience sqlyog is very good. There is a free version which you can use
for executing SQL queries, ofcourse you will be stripped of some advanced
features.

You can run multiple queries at once using shift+F5. I suggest you to try
this out once.

sujay

-----Original Message-----
From: SGreen@unimin.com & #91;mailto:SGreen@un
imin.com]
Sent: Friday, September 30, 2005 7:14 PM
To: Rob Agar
Cc: 'Mysql '
Subject: RE: MySQL Query Browser

"Rob Agar" <rob@wildlime.com> wrote on 09/29/2005 08:27:37 PM:

> hi Scott
>
>
> The only way I've found is to put the queries in a .sql file and load
> it via File > Open Script. It doesn't accept multiple typed in
> queries, even if they are separated by semicolons.
>
> hth
> Rob
>
>
>
He can just start a new script tab, can't he? That's how I do it. I don't
know why they have two different types of tabs (one for multi-statements and
one for single statements) but they do.

File -> New Script Tab

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Pooly

2005-09-30, 11:23 am

2005/9/30, Sujay Koduri <SujayK@andale.com>:
>
> I am not saying MysQL Query Browser is anyway bad or inferior, but as for=
my
> experience sqlyog is very good. There is a free version which you can use
> for executing SQL queries, ofcourse you will be stripped of some advanced
> features.
>
> You can run multiple queries at once using shift+F5. I suggest you to tr=
y
> this out once.
>

the no longer supported Mysql Control Center, can do it as well. It
supports single/multiple query without tricks. You can even directly
edit your dataset (and not do the annoying : "edit"+ do your stuff +
"apply changes" of MysqlQuery Browser )

> sujay
>
> -----Original Message-----
> From: SGreen@unimin.com & #91;mailto:SGreen@un
imin.com]
> Sent: Friday, September 30, 2005 7:14 PM
> To: Rob Agar
> Cc: 'Mysql '
> Subject: RE: MySQL Query Browser
>
> "Rob Agar" <rob@wildlime.com> wrote on 09/29/2005 08:27:37 PM:
>
> He can just start a new script tab, can't he? That's how I do it. I don't
> know why they have two different types of tabs (one for multi-statements =
and
> one for single statements) but they do.
>
> File -> New Script Tab
>
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql? unsub...mail
.com
>
>

--
Pooly
Webzine Rock : http://www.w-fenec.org/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Ed Reed

2005-09-30, 1:23 pm

--=__Part22005145.0__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

I think Control Center is a much better tool then the combination of Query =
Browser and Administrator. I still use Control Center for my day to day =
stuff and only check out Query Browser when new versions come out to see =
if they've solved the major problems.
=20
I think they've gone completely in the wrong direction with these tools =
and I even told members of MySQL-AB at this years user conference. I gave =
a written list of suggestions and not a single one of them has been =
addressed in the program. It's definitely not an intuitive application and =
could be so much better if they'd just take the best ideas from all the =
other tools that are already out here. I don't think they've done that; it =
seems as if they've created this thing based on the way they _want_ to use =
it and not the way users _need_ to use it.

2005/9/30, Sujay Koduri < SujayK@andale.com >:[color=darkred]
>
> I am not saying MysQL Query Browser is anyway bad or inferior, but as =
for my
> experience sqlyog is very good. There is a free version which you can =
use
> for executing SQL queries, ofcourse you will be stripped of some =
advanced
> features.
>
> You can run multiple queries at once using shift+F5. I suggest you to =
try
> this out once.
>

the no longer supported Mysql Control Center, can do it as well. It
supports single/multiple query without tricks. You can even directly
edit your dataset (and not do the annoying : "edit"+ do your stuff +
"apply changes" of MysqlQuery Browser )

> sujay
>
> -----Original Message-----
> From: SGreen@unimin.com & #91;mailto:SGreen@un
imin.com]=20
> Sent: Friday, September 30, 2005 7:14 PM
> To: Rob Agar
> Cc: 'Mysql '
> Subject: RE: MySQL Query Browser
>
> "Rob Agar" < rob@wildlime.com > wrote on 09/29/2005 08:27:37 PM:
>
> He can just start a new script tab, can't he? That's how I do it. I =
don't

> know why they have two different types of tabs (one for multi-statements =
and
> one for single statements) but they do.
>
> File -> New Script Tab
>
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql=20
> To unsubscribe: http://lists.mysql.com/mysql? unsub...l
.com=20
>
>

--
Pooly
Webzine Rock : http://www.w-fenec.org/=20

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql=20
To unsubscribe: http://lists.mysql.com/mysql? unsub... /> eld.com=20=

--=__Part22005145.0__=--

Sponsored Links