Colin Shreffler <[EMAIL PROTECTED]> wrote on 11/26/2005
04:44:26 PM:
> Does anyone know how to separate queries so that I can run multiple
insert
> statements at once?
>
> For example, from within MySQL Query Browser, I want to load a file
> containing multiple inserts and then run it. It erro
Does anyone know how to separate queries so that I can run multiple insert
statements at once?
For example, from within MySQL Query Browser, I want to load a file
containing multiple inserts and then run it. It errors however on trying to
run the following queries:
insert into project_type (proj
McNeil [mailto:[EMAIL PROTECTED]
Sent: Monday, June 14, 2004 1:24 PM
To: MySQL General
Subject: Multiple Queries
RE -
I have a situation where, within a PHP loop, I am creating over one
hundred SQL statement (INSERTS and UPDATES).
Would it cut any overhead to send 20 ";" seperated quer
RE -
I have a situation where, within a PHP loop, I am creating over one
hundred SQL statement (INSERTS and UPDATES).
Would it cut any overhead to send 20 ";" seperated queries in one
mysql_query() statement, and therefore only execute mysql_query() 5
times for 100 statements, as opposed to sendin
8 Fax to:
PM Subject: RE: Sending multiple queries
to MySQL
(sorry, hit
.
Ed
-Original Message-
From: Andy Hall [mailto:[EMAIL PROTECTED]
Subject: Sending multiple queries to MySQL (sorry, hit send by
accident!)
Hi,
I have a situation where, within a PHP loop, I am creating over one
hundred SQL statement (INSERTS and UPDATES).
Would it cut any overhead to
Hi,
I have a situation where, within a PHP loop, I am creating over one hundred SQL
statement (INSERTS and UPDATES).
Would it cut any overhead to send 20 ";" seperated queries in one mysql_query()
statement, and therefore only execute mysql_query() 5 times for 100 statements, as
opposed to sen
Hi,
I have a situation where, within a PHP loop, I am creating over one hundred SQL
statement (INSERTS and UPDATES).
Would it cut any overhead to send 20 ";" seperated queries in one mysql_query()
statement, and therefore only execute mysql_query() 5 times for 100 statements, as
opposed to sen
Tim McDonough writes:
>The solution I presently have does a query for the first criteria.
>Then, I loop through the results of that query and do another query
>for each returned row. This produces the desired results but requires
>a lot of queries, i.e.-- if the first query returns 1000 customer
> I have an application where I want to look for records that match
> certain criteria and then for each item found do a second lookup for
> additional information. Normally I would do a join. In this case
> however I want to display each of the results from the first of the
> two criteria whether
* Tim McDonough
> I have an application where I want to look for records that match
> certain criteria and then for each item found do a second lookup for
> additional information. Normally I would do a join. In this case
> however I want to display each of the results from the first of the
>
CTED]
Sent: 4/9/04 8:20 AM
Subject: Better Solution than Multiple Queries?
I have an application where I want to look for records that match
certain criteria and then for each item found do a second lookup for
additional information. Normally I would do a join. In this case
however I want to di
I have an application where I want to look for records that match
certain criteria and then for each item found do a second lookup for
additional information. Normally I would do a join. In this case
however I want to display each of the results from the first of the
two criteria whether or not the
This would be called transactions: your're looking for COMMIT/ROLLBACK. As
far as I know, transactions are only available on BDB and InnoDb table
types. See
http://www.mysql.com/doc/en/Transactional_Commands.html
http://www.mysql.com/doc/en/InnoDB_overview.html
At 12:24 AM 1/
Hi,
I looked a lot and I couldn't find a solution to this problem:
Ex: I have 5 queries. I run them and one of them fails. The rest are ok.
So 4 tables are affected and one is not. Is there a way of testing the
queries if they will be successful and only if all of them are then they
should be run
Hi,
I looked a lot and I couldn't find a solution to this problem:
Ex: I have 5 queries. I run them and one of them fails. The rest are ok.
So 4 tables are affected and one is not. Is there a way of testing the
queries if they will be successful and only if all of them are then they
should be run
You can create another frame that's "invisible" by having a zero height or
width. This can be your page that does all the queries and refreshes.
You can then use the javascript command document.write() to update the other
frames without having to hit the server again. Or, retrieve the data in the
You're running 3 entirely independent scripts, so they can't share a connection.
You may save an infinitessimal amount of time by using mysql_pconnect() instead of
mysql_connect(), which will give each process/thread a permanent database connection,
so it doesn't have to connect every time.
Ad
Sorry If this is the wrong list for this topic, I hope someone can shed some
light onto my problem.
I am building a php/ Mysql web site for a client which is a picture gallery.
The web site has 3 frames (required by the designer so that the whole thing
doesnt refresh all the time).
Frame 1- Navig
Hi
insert into mytbl (a1) values (12),(13),(14);
cheers
Mark
---
On Mon, 15 Apr 2002, Bill Adair wrote:
> Hello all,
> I'm in a mysql client session and I want to do multiple inserts
> into a table (or run a multi-query script etc). Thi
Hello all,
I'm in a mysql client session and I want to do multiple inserts
into a table (or run a multi-query script etc). This doesn't work
so what's the correct seperator / methodology?
INSERT INTO mytbl (a1) VALUES (12);
INSERT INTO mytbl (a1) VALUES (13);
INSERT INTO mytbl (a1) VALUES (14);
\
t all possible or if it's practical to combine them into one large
> query. The single query I tried doesn't produce the proper results. The multiple
> queries below do produce the desired results, but I'd like to combine them into
> one single query, if it's possible.
Th
[EMAIL PROTECTED] writes:
> I've been trying to figure out a way to combine all these queries into one query
> , if it's at all possible or if it's practical to combine them into one large
> query. The single query I tried doesn't produce the proper results.
[SNIP]
I'm not surprised, seeing how
I tried doesn't produce the proper results. The multiple
queries below do produce the desired results, but I'd like to combine them into
one single query, if it's possible.
TOTAL SUMMARY PAYIN's/PAYOUT's(single query)
select format(sum(po.refund_charge*.95),2) as RefundC
24 matches
Mail list logo
