isolation level are you using now.
I am using the default which i beleive is REPEATABLE READ. The
particular query that is failing is done using autocommit as it a
standalone query.
Thanks
tony
>
> sujay
>
> -Original Message-
> From: Tony Leake [mailto:[EMAIL PROTECTED]
Hi,
I have a query:
UPDATE dbseXyzOrders.tblOrder SET intPoUid = 98 WHERE intOrderUid =
10798
intOrderUid is the primary key
There are 25 columns in the table and a further 8 of these have indexes
on them. The table is innodb
I have just tried to run the above query 3 times and i got the
On Thu, 2005-09-29 at 16:15 +0100, Nuno Pereira wrote:
> [EMAIL PROTECTED] wrote:
>
> This one is interesting in terms of concurrency...
>
> Is the app2 the one responsable for setting the flag? I supose that it is.
> If that happens it's important that app2 doesn't mess with the flag, i
> mean
On Thu, 2005-09-29 at 09:30 -0400, [EMAIL PROTECTED] wrote:
> The key here is
> that you are making multiple changes from app1 that really should be
> within a transaction. The entire process of writing sales data and
> unsetting a flag from app1 needs to be transacted. That way the other
>
Hi
I have 2 applications communicating via a mysql database
the db is 4.1.8 running on a debian linux system.
All tables are innodb
app 1 1 runs on a windows machine, is written in c# and talks to the db
with odbc
app 2 runs on the same machine as the db and is writtin in php.
Here's the pro
On Fri, 2005-09-16 at 14:02 +0100, Mark Leith wrote:
> http://dev.mysql.com/doc/mysql/en/group-by-modifiers.html
>
perfect, thank you.
tony
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I'm sure I read somewhere about a new function that would give the
totals of all columns, ie if i have 2 cols, numberOfOrders valueOfOrders
for a range of dates i can get something like the following
Date numberOfOrdersvalueOfOrders
01-09 4 20.00
02-09 6