MYSQL :: Running Multiple Queries In Query Browser

Running Multiple Update Querries In Query Browser
I am trying to run multiple update statements together from the MySQL Query Browser. For example:

update table1 set field1 = "123", field2 = '456' where rowid = 'abc'
update table1 set field1 = "321", field2 = '654' where rowid = 'efg'

I can run them one at a time, but I cannot run multiple updates at the same time. I have 1100 of them to run, so I don't want run them individually.

In M$ SQL I can just put a ; or GO at the end of each line to seperate it from the next. How can I do this in MySQL?

Multiple Queries Within 1 Query
In the past, I have queried the database, grabbed one tidbit of information, then performed a second query to find the second tidbit, based on the information gathered from the first query. As you can probably guess, this method, although effective, is very slow.

All of this comes from one table, in this case, named 'horse.' I thought that INNER JOIN was the way to solve this delimma, but my query causes errors. I am hoping someone can get me started down the right path.

Here is my query:

$result = mysql_query("SELECT p1.name,p1.dob,p1.color,p1.dam,p1.starts,p1.wins,p1.seconds,p1.thirds,p1.earnings,p1.mareFamily,p1.gender,p2.sire AS damSire FROM horse AS p1 WHERE sire='$prog_name' INNER JOIN horse AS p2 ON(p1.dam=p2.sire) ORDER BY p1.name ASC");

This cause the following error:

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 'INNER JOIN horse AS p2 ON(p1.dam=p2.sire) ORDER BY p1.name ASC' at line 1
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource

I am using MySQL 4.1.13-standard.

Running Queries
I am running phpbb forums, and I had run into a problem. They gave me a line of code that Im am supposed to run to fix my problem. Now that creates a problem, because that line of code is wrong sql says??

Heres the code..

ALTER TABLE phpbb2_users ADD COLUMN user_timezone float DEFAULT '0' NOT NULL

I think the problem lies within the user_timezone part. I get an error 1064, and also it says that the database table phpbb2_users is not there, which I am looking at

Running Queries To Mysql In Linux
How i use mysql in linux without the client and with it?

Complex Queries Versus Multiple Simple Queries
I am constructing a database to contain information about stories posted on my site. Information included will be things like title, author(s), genre(s), story codes, synopsis, etc.

I worked out that storing this information properly, so that it can all be searched on, could take as many as ten tables.

My question is this: Is a single complex query really better (more efficient for the server) than multiple simple queries? In other words, I may need the information for as many as 25 or even 50 stories for a single page.

Is it better to get all of the information out of a single, massive, complex query, or is it acceptable to get the information essentially one story at a time, which could mean 25 or 50 simple queries...?

Mysql Running All Queries Double ? How To Avoid ?
Sometimes, when my database server has been slow and building up hundreds of queries, I have the impression that mysql is running 'double' of triple . It's hard to explain, but when I look at mtop (a tool to see what queries are active and what time they take to finish) , I see a lot of queries that seem to hang and that are present more then once. Some of them have unique data in them that can not happen just by refreshing a form. When the peak moment is over, and I check my site, then I sometimes see for example the exact same forum post 3 or 4 times in the same thread. Needless to say, this causes a lot of extra load on my database.

I'm not sure what really happens, but it seems like mysql server is just piling up queries wich it can not process fast enough, and those queries seem to come in several times again. I use seperate webservers, but even if I reboot them all, the extra queries still come in as soon as the webserver is back up and php scripts start to work again. The only way to stop it all, is to restart mysql, but that is something that I can not just do very easily. I rely on several heap tables for my site and they need to be refilled with data from normal tables. So restarting mysql is something I only like to do at night, with very few visitors online.

I hope I'm explaining my problem well enough. And I hope there is a way for me to check what really is going on, and if there is a way to stop mysql from 'running double' ?

Mysql Stops Running Queries After Approx 1 Day
I have a PHP script that runs 24x7 and reads then deletes from a table about once every couple of seconds.

However, after about a day, I start getting the error "$result is not a valid mysql resource etc..".

Looking in the query log, mysql has stopped logging the queries - so I presume they are not being run/received by the daemon.

If I restart the script, it will work fine again for around a day.

Does anybody know what would be causing this? Are there any logs than can help?

Having run the script for about 5 minutes, I'm already up to "mysql resource id #180" so I guess by the time the script stops working, we could be up to the tens of thousands.

Could mysql be running out of resource IDs? Once the query has been execute, I don't need to store it any more so can I somehow get it to start re-using some of the old resource IDs?

Query Browser
I am looking for graphical query tool to work with MySQL 4.1. I installed a copy of their query browser, but get the following error.

MySQL Error Nr. 1251
Client does not support authentication protocol requested by server; consider upgrading MySQL client

Anyone have any insight into this error as I think it should work with 4.1, or otherwise have any suggestions for a query tool?

Query Browser
I'm having a hard time with the Query Browser. I can't figure out how to view the rows. When I click on the table in the Browser, nothing shows up and at the bottom there is a message saying Library Error Number 3. I am sure this is something simple but it's making me tear my hair out.

Mysql Query Browser
I wander how can i connect to database by using mysql query browser using my cpanel account
remotemysqlhost,username, password

Browser Address Bar Query
How could I execute a query in the address bar of my web browser?

Starting Query Browser
i installed mysql server 5.0 and other GUI components and the connector.in windows XP from the start menu i click my sql query browser and the dialogue box appears asking the host ,username and password and giving the port 3306(already filled in)i give localhost and the password which i gave during installation ,and an error comes saying mysql error 1045:access denied for user ODBC@localhost.

Using The MySQL Query Browser
I am in the RESULTSET 1 tab and I've tried to run multiple querys in the query window such as:

SELECT PKEY, ENTITYCODE, REQNNUM FROM INVPO.INVPO_POI;
select * from INVPO.INVPO_POI_APV

and I've also tried this in the Script 1 tab but I cannot see any results.

I just want to be able, like in Query Browser in SQL Server, to see sets of results.

Query Browser - Blanko-ed
I am new to this MySQL, and I am using the MySQL Administrator GUI program. I've managed to create the tables but I am unable to populate the data into the table - when I right click the table, the option EDIT TABLE DATA is blanko-ed, but the rest are clickable. When i choose TOOLS, the MySQL Query Browser option is also blanko-ed.

I installed everything under Administrator account level, and I do not know what is the reason. I did not change any setting so far.

Mysql Query Browser
I am trying to run the following statements in mysql query browser

DROP TABLE IF EXISTS `bedbugs`.`airports`;

CREATE TABLE `bedbugs`.`airports` (
`city` char(20) default NULL,
`country` char(20) default NULL,
`name` char(20) NOT NULL default '',
PRIMARY KEY (`name`)
);

basically two different queries through one query window.

I get the following error:

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 ';
CREATE TABLE `bedbugs`.`airports` (
`city` char(20) default NULL,
`cou' at line 1

Can someone explain what is going on. If I comment out either query - the other one runs fine (basically I can run one at a time).

Is this some sort of limitation of the query browser?

Query Browser 1.1.4 Conflicts
I am using MySQL Server 5.0.2 alpha-nt with Mysql query browser 1.1.4 on winXP.
1.
When i open the query browser a WinXP error reporting dialog opens claiming 'mysql-nt.exe has created some error...
2.
When we execute scripts in query browser 1.1.4, it only shows if any errors have occured. How do i see the results of the script. 3.
Besides the statement ' select @var; ' in the browser shows @var as containing NULL even though it soes contain some value
ALso can someone guide me to the download page of mysql server 5.0.1.

MySQL Query Browser
I am using the MySQL Query Browsers, and when I am performing some actions, like changing the character set or collation, it gives my syntax errors and won't commit the change.
Does anybody else have these problems with the MySQL query browser? And how do I fix these?
I am running on MySQL 5.0 Beta, but had same errors on MySQL 4.1

PhpAdmin & MySQL Query Browser
I am new comer to PHP. I come across phpAdmin & MySQL Query Browser, which to my opinion, perform similar task.

Can you guys tell me, phpAdmin & MySQL Query Browser, which one is better?

Export Query Results Through Browser
This would seem simply enough but I am struggling with it. I am using PHP 4 and Mysql 5.0 I need to take the results of a query and allow the user to download the results....

How To Call With Query Browser A Sp With Out Parameter?
I've a stored procedure like as sp_add_value(IN value int, OUT msg Varchar(10)) and i not get call in query browser.

Error While Connecting To The DB Using Query Browser
I am a newbie to mySQL world. I have sucessfully installed the mySQL and also have created a schema and a few user accounts. However when I try to connect to the DB from a REMOTE machine using the mySQL Query Browser, I get the following error:

"MySQL Error Number 2003 - Cant connect to mySQL server on 'myserver.mydomain.org'". However, I am successfully able to ping the server. Here are the specifics:

1. The Host Server where mySQL has been installed is at my home and is connected to the internet via a Broadband Linksys Router.

2. As I do not have a static IP, I registed for a Dynamin DNS service. I made sure that the port 3306 is opened, both at the router and on the machine where mySQL is installed.

3. I am trying to connect to the mySQL server from my home laptop, which is also behind the same Linksys router. I have also tried connecting from a truely remote machine (the one which is not behind this router, but is connected to internet) - again unsuccessfully.

4. The user account using which I am trying to connect has an 2 entries in the mysql.User table - one with column Host=localhost and another with column Host=%.

5. AFter a bit of googling, I found out that this is a common issue when BIND_ADDRESS and SKIP_NETWORKING are left uncommented in my.cnf file. However, I do not have a my.cnf file in the filesystem. And I have not created one..

6. I am able to connect to this mySQL server using SSH (using mysql -h localhost -u userName -p)even from a remote machine.

However I am not able to connect using mySQL query browser. Am I still missing something here?

MySQL-Query-Browser Installation
I am currently migrating a db from SQL Server & MySQL and ? (front end yet
to be decided upon) As I familiarise myself with MySQL populating tables
etc can be quite clumbersome. After reading the MySQL site it appears the
"Query Browser" is the correct tool which I've downloaded, extracted and
followed the instruction for installing it... without success, it doesn't
work.

To clarify what I've done I've:
Downloaded: mysql-query-browser-1.1.6-linux.tar.gz
Extracted it using: tar -vzxf mysql-query-browser-1.1.6-linux.tar.gz
In the doc directory there is a html file that explains the installation
procedure under Linux...

"To install MySQL Query Browser, run this command:
shell> tar --directory=/opt -xzvf mysql-query-browser-version-linux.tar.gz

This installs the application binary in /opt/mysql-query-browser/bin. Change
into that directory and run mysql-query-browser to start the application.
You can replace /opt with your desired installation path."

I have done all of this and the files were extracted
to /opt/mysql-query-browser as expected.

The question is, how do I run the application?

Query Browser 1.28beta OS X Not Usable (for Me)
I'm having some strange problems which seem to have only to do with the Query Browser 1.28 beta for OS X. What I mean is, regardless of what MySQL database I connect to (local OS X or on a Win2k server on the same network), the problems I list below happen consistently; at the same time, Query Browser 1.28beta running on that same Win2k server can manage both its own and my OS X box's MySQL installations just fine. So on to the problems ...

Mysql Query Browser Import From Csv
The only way that I was able to backup my tables was from the mysql query browser export to csv option. I know that I am stuck with having to recreate the table schema's but right now I am having problems importing the tables. I am using phpMyAdmin, since there is no import feature in query browser. The problem that I am having is because double quotes (") are not escaped (") in the text fields, and phpMyAdmin is unable to insert all of the data. Is there a way to fix this issue, I have been able to open all of the files with microsoft excel, which seems to sort the columns out fine, even though they aren't escaped.

Can't Connect Using MySQL Query Browser
I'm having a little problem connecting remotely to my MySql database. First a little background on my setup. All machines are on my home LAN behind a router. Linux Machine; Ubuntu Linux with MySql installed and running without a problem, command line. Windows XP machine with MySql query browser client installed.

The problem comes in with trying to connect the XP machine to the Linux box to access the sql tables. It mainly says it can't connect to my database/schema. I know the database is fine(or at least it seems) because I can SSH over to it and run queries without a problem. I've tried using the IP address, the machine name to connect but nothing works. I've investigated the .sock files, ports and for some reason I can't get a good connection with the Windows client software to my database.

Query Browser Won't Install On SuSE 9.2
MySQL Query Browser won't install on SuSE 9.2 because it requires the following:
libgal-2.0.so.6
libgal-a11y-2.0.so.6

These do not appear on the SuSE installation disks.
I googled and didn't find them available for download
What can I do?

Insert A Record Using MySQL Query Browser
I know I can probably type in the actual query, but I was wondering if there was a means of inserting a record without typing "insert into table_name (blah, blah2) values (blah, blah)". I'm looking for a method as easy as typing into an Excel spreadsheet or Access DB. (I know I'm gonna get bashed for mentioning Microsoft products.)

Error After Installing MySQL Query Browser V. 1.1.20
After installing MySQLQuery Browser on a new computer (Windows XP Pro SP2), it works but there is a constant and rapidly flashing error on the bottom of the application. When you exit the application you get the following error:

Application Error
Exception EAccessViolation in module MySQLQueryBrowser.exe at 0003F211. Access violation at address 00040211. Read of address 00040211.

This application works on 2 other PCs but is acting crazy on the new PC. Any ideas? I know nothing about SQL, I'm just the PC support.

How Do You Import A Mysqldump File Using Query Browser?
I have a MySQL 4.1.5-gamma-nt-max instance running on a Windows 2000 Server box. I have tried creating a script to restore a mysqldump backup file to a schema on that server. Here is my syntax:

set foreign_key_checks=0;
source b:/folderwithdata/data.043006
set foreign_key_checks=1;

When I execute this locally on the server from the command line, it executes without a hitch. However, the server is going to be located in a server farm where I will not have access so I have tried to execute this from my workstation using Query Browser. I launch Query Browser and execute the script and get the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use. ErrorNr: 1064 near 'SOURCE B:/FOLDERWITHDATA/DATA.043006 SET FOREIGN_KEY_CHECKS=1' at
line 1

Like I said, it executes fine on the server via command line so I know it's not bombing out on some syntax within the file itself. So I'm assuming it has something to do with how I'm writing the script in the GUI itself.

CREATE TABLE And MySQL Query Browser
I am using the ODBC 3.51 Driver to Do a "create database" and then create some tables on that database.

I see in the ..mysqldata directory my new database I have created and the associated .frm files, however MySQL Query Browser and Administrator do not see these schema's.

I am guessing it may be due to user privileges. MySQL is running locally and the connection string does not contain a Username and password.

Also, when I do show databases from within the Query Browser, it does not show my Database, only the one that I had created manually.

There must be some more setup that I am not aware of to register the Database or something.

MySQL Query Browser - ERROR 1044
I'm new to MySQL and am having a frustrating time figuring out some of the tools. I'm getting ERROR 1044 when I try to execute the following .....

MySQL Query Browser. Result Set Read Only
I'm developing a client/server application with mySQL. The mysql server (plus database) is on a Windows XP LAN pc in another office.

I installed mySQL several months ago and have been using Administrator and Querybrowser locally on a regular basis to administer and fiddle with the database on the other pc. I don't believe I've changed any settings.

I noticed a couple of weeks ago that if I tried to edit table data from Administrator, Query browser wouldnt display but would remain in task manager process list forever. If I did the same directly from query browser I would receive a result set ready to edit.....

USE After DROP And CREATE (script In Query Browser)
I'm writing a simple script that creates the database and tables:

------------------------------------
DROP DATABASE IF EXISTS mydb;
CREATE DATABASE mydb CHARACTER SET utf8 COLLATE utf8_unicode_ci;

/*workaround: use mysql; */
use mydb;

DROP TABLE IF EXISTS movie;
CREATE TABLE movie (
id int not null auto_increment primary key
);
------------------------------------

When executing, Query Browser says "No database selected (1046)" on lines with table names. I add USE <dbname> after its creation, but it only works if the previous default database is different. A work-around is to add "USE mysql" just before the real USE, but it's ugly.

Any solutions?

Unable To Do Joins With MySQL Query Browser
I downloaded the Query Browser for Windows. I try to join two tables as described in the manual, drag over the JOIN tables tab but nothing happens. The query remains as is.

How To View Arabic Data In MySQL Query Browser
I am making a website on linux and i am using a program called rekall to view the database and also the table was created using this program.

most of the data in the database are in Arabic and rekall views the data in an acceptable manner with some errors and without any configuration

but when I tried MySQL Query Browser on windows and several other programs including navicat, toad, heidiSQL all the arabic data was not viewable except the data in blobs which can be exported to extenal files

The website encoding is [ar-eg] and [utf-8]
I want to view the arabic data stored in the table using a windows program
and if the program is fast and simple it would be much better as I am not the one who is going to use it

Mysql Query Browser...how Do I Ignore " Within A SET Statement?
I'm trying run this in mySQL query browser

Update xcart_classes x
Set classtext = "5 Year Protection <a href="javascript: void(0);" onclick="javascript: window.open('etp.htm','HELP_POPUP','width=406,height=261,toolbar=no,status=no,scrollbars=yes,resizable=no,menubar=no,location=no,direction=no');" class="PopupHelpLink">Learn More</a>"
where Classtext = "Add 5-Year Extended Protection";
Obviously it fails, and I'm pretty sure it's because of the double quotes on my SET statement...any idea on how to avoid that?

MySQL GUI Tools Query Browser/Admin Login
I've just installed the GUI tools so I can get a little help with queries and table design, and I am not able to log into the administrator or the query browser. The login screens show up, I enter all the correct data, then the form grays out except for the cancel button and does nothing. Doesn't even eat up any system resources, so it doesn't even look like its trying.

I've turned off all firewall settings in case that might have cause the issue and it still doesn't work.

Executing Shell Command From Mysql Query Browser
This works fine when executing the shell command inside the MYSQL in command line

mysql> ! ls /home/www/htdocs/test
1000.xml class email test.xml test1.xml test2.xml

But when i execute the same with dynamic SQL and executed in TOAD for MYSQL, it throws error

SET @vSql:= '! ls /home/www/htdocs/test';
PREPARE vStmt FROM @vSql;
EXECUTE vStmt;

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 '! ls /home/www/htdocs/middleware/test' at line 1

Can some one clarify me Whether is that possible to execute the Shell commands from the query browser or it can be only used in the command line?

Aggregated Variable Only Work With Transaction In Query Browser?
I want to select rows and use user variable to generate an incremental id for the result. For example, I want the following query

select @id:=(@id+1) as id from file_list limit 5

to return 5 rows with values 1 to 5. However, the result is ....

Query Browser When Opened Via Remote Desktop Connection
I have a MySQL database that I set up by running a couple of .sql scripts.

The .sql files are fine and not corrupted.

But they are located on our server in headoffice.  When I try to open them in MySQL Query Browser (also installed on the headoffice server) via Remote Desktop Connection, the Query Browser opens a new script tab but does not display anything (i.e. no text in the scipt tab).

Also, I'm sure this is related, I can enter a query in to the execute box and execute it, but you cannot see the text as it is being typed.  However it is there as when I click the Execute button the query runs fine.

Any ideas why I am not able to see any entered text in the Query Browser window?  I have tried uninstalling and reinstalling Query Browser a few times, but this has not cured the problem.

Changing Order Of Columns Using Mysql Query Browser
I have a table that is already created and I wanted to add a column, but put it somewhere in the middle of the table. is there a drag and drop (or something just as easy) method to move it up in the table? or do I have to re-create the whole table?

Auto Saving Results From Query Browser Into Excel Format
Is there a way I can save the output(s) of select statements (in query browser) to excel files directly , so I can run this as stored procedure or script? (I have quite a few queries and wanted to automate the process so anyone can do it.)

Importing W/sql Scripts W/utf8 Encoding Using PhpMyAdmin & MySQL Query Browser
NB: Some of this is related to the The Definitive Guide to Web Character Encoding article but I thought it would be best to ask these questions in here because of your experience with MySQL. Please excuse me if I've made a mistake in making this post here.

QUESTIONS Does anyone know how to correctly run an sql import script with utf8 encoding in phpMyAdmin so that the utf8 text appears correctly when the content is pulled into a browser?Does anyone know how to view and edit text in phpMyAdmin & MySQL Query Browser so that the characters will stay in utf8 format for phpMyAdmin & MySQL Query Browser and for the browser when it pulls the data from the table?
BACKGROUND
I've had some difficulty running sql scripts from phpMyAdmin that have utf8 encoding and having that content appear correctly in a web page. I've also had issues with viewing and editing content in phpMyAdmin and MySQL Query Browser when the tables and content are set to utf8.The table and columns all have utf8 set as the character set.The sql script is encoded as utf8.The web page that pulls the data from the tables has the <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> in the header.MySQL Query Browser has Arial Unicode MS set as its font so that I can view most unicode characters in it.
After the sql script is run against the db via phpMyAdmin the characters appear without issue in phpMyAdmin or MySQL Query Browser but when they're pulled via a PHP script to appear in a web page the characters do not appear correctly.

If I submit content via a browser's web form that's encoded with utf8 the characters come back in the browser without issue but the characters do not appear correctly in phpMyAdmin or in MySQL Query Browser when I browse the tables.

If I edit the content in a table using phpMyAdmin or MySQL Query Browser the content appears correctly in phpMyAdmin & MySQL Query Browser but no longer appears correctly in the web page.

SOLUTION
For now I found that using a PHP script to read and process the sql file I can get the data into the db and the content will appear correctly in a web page but this avoids the use of phpMyAdmin & MySQL Query Browser. I'd like to be able to use phpMyAdmin & MySQL Query Browser every now and then ... any ideas on what I might be doing wrong?

Multiple Queries?
well not really sure how to explain this one.
I wrote a reate me script. One tha tallow syou to add a photo and leave comments for a photo. What I want to do is allow the admin to search thorugh all the comments. sure, easy query to just search comments, but I want them to be allow to search for a photo and grab the commetns on that specific photo.
the photo table is linked to the comment table by photo.picid=comment.subjectid. I also want to grab the user info in this and that is linked to both tables really. but I could use the comment table like this, comment.postedby=user.id.
now the photo names are the users id along with the date. so it would be like so
1_2006_10_25_1340.jpg
so i thought I would let the user search for the user id and grab all photos with that id and load the comments as well. but I am following short. I get the photos, but no comments, or I get the comments but short on photos and the comments are the same comment for both photos. various mixed results
The trick is that on the same search form I will allow them to search just comments, easy, or the date of the comment, or with the user so they can see all of the comments by said user. but getting the difference between all searchers is killing me cause I want to do only one query if I could.
I don't think the table structure is important as you know th erelationship between the tables. but if you need it let me know.
if any of this made sense what idea would you have for the query?

Multiple Queries
I'm currently devoloping a little program, where I have a lot of small mysql-queries.

First I tried executing them as soon as i had the data, but that was awfully slow.
Now I'm writing all Queries to a big String and thought I could just execute it.
The file looks like:
call myfunc (1,2);
call myfunc (1,3);
call myfunc (2,5);

But when i try I get this error
You have an error in your SQL syntax; [...] to use near '; call myfunc (1, 3);

I'm using C++.Net with the MySQL ODBC 3.51 Driver. The code looks like this:
OdbcConnection * conn = new OdbcConnection(MYSQL_CONNECTION_STRING);
conn->Open();
DBC = new OdbcCommand(myBigQuery, conn);
DBC->ExecuteNonQuery();
conn->Close();

If I try to save the string to disk and then load it through the mysql console it works just fine (with source myBigQuery.sql)
If I send every call as its own query it works

Multiple Queries At Once
I have a 2 part query which works fine when I paste it into phpMyAdmin, but when I go to use it in PHP, it error's after the semi-colon between the commands.

Multiple Queries
I want to make two queries with a single script, because I want to be able to output different results, in the event that there is no match for the first query, which searches for a variable passed from a select menu. But there is one option in the select menu that has no match in the db, so I want to return different results, which in this case, is all rows (All Models) for the given column (Models).

I have gotten this to work, but it doesn't seem intuitive. I tried using the if and else clauses with the actual queries, but without success. Would someone be willing to show me the proper way of going about this--how to script it--but produce the same results. Code:

Multiple Queries W/ 4.0.x (C API)
When executing multiple queries, which return a result set, must
mysql_free_result be called after retrieving each result set using
mysql_store_result? My concern is that if the result was not freed
after each retrieval, that perphaps it may impose a memory leak. Or,
does MySql reuse previously allocated memory for subsequent result
sets?

My app performs several back-to-back select and select/insert queries.
Just need to know how to handle this action.

Running Multiple Queries In Query Browser

What is the magic word to get query browser to execute a string of queries?