Hi Martin,
Sorry my example wasn't clearer. I am doing a commit or rollback
depending on the success of the overall transaction. What I don't do is
retry parts of the transaction upon deadlock.
Thanks for pointing that out, though!
Best,
Mike
On Mon, 2009-05-25 at 16:46 -0400, Martin Gaint
Hi there,
I am trying to sort through an occasional problem I am having with
deadlocks I am facing with a series of inoodb tables:
cases (PK id)
|___ cases_workcodes (PK id, case_id / FK case_id)
|___ cases_invoices (PK id, case_id / FK case_id)
|___ cases_additional (PK id, case_id / FK case_
ue on orderingcol ...
select a.*,b.*
from a inner join b on a.id=b.id
left join c on b.id=c.id and b.orderingcol < c.orderingcol
where c.orderingcol is null;
PB
-
Michael Caplan wrote:
Hi there,
I'm following up on a thread I started yesterday with a new thread,
cause I'm now
Hi there,
I'm following up on a thread I started yesterday with a new thread,
cause I'm now looking at a different problem: limiting the result of a
join. For example:
SELECT
*
FROM
a
JOIN
b
ON
a.id = b.id
If I wanted all records from "a" and only the first record from "b", how
wo
og/mysqlckbk/chapter/ch03.pdf+mysql+query+obtain+last+record&hl=en&gl=us&ct=clnk&cd=7&client=firefox-a
<http://72.14.203.104/search?q=cache:8uOO2iKVffAJ:www.oreilly.com/catalog/mysqlckbk/chapter/ch03.pdf+mysql+query+obtain+last+record&hl=en&gl=us&ct=clnk&cd=7
ng in
between, and the last.
Any ideas?
Thanks,
Michael
Néstor wrote:
I beleive that when you do your query you can add 'limit 1' and the
query will return the
first record only.
Néstor :-)
On 8/4/06, *Michael Caplan* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>
I just noticed that MSAccess and SQL server support FIRST() and LAST()
functions. Is there an equivalent in MySQL? My research has come up
with nil so far.
Thanks,
Michael
Michael Caplan wrote:
Hi there,
I am trying to figure out how to "flatten" the result set of a join
q
Hi there,
I am trying to figure out how to "flatten" the result set of a join
query using aggregate functions. For several fields (b.refering_url,
c.string, b.first_page, b.last_page) I need to pull out the _first_ or
_last_ item as ordered from the records returned from the join.
However,
-+
However, these subqueries look like they will be wildly inefficient.
What I gather the DB (MySQL) is doing here is getting _all_ attributes
of type X for all articles, and then joining that result set together
with article ID of the current row.
Any ideas?
Michael Cap
set and flatten it so that all
attrib_key values => corresponding attrib_value, but this is less than ideal.
I'm wondering if any of you have ideas how I can acheive the desired result with
some creative SQL?
Thanks,
Michael
--
Michael Caplan - Zend Certified PHP Engineer
Programming
installs. If you have any pointers on tweaking a
freeBSD install, it would be very helpful.
Regards,
Michael Caplan
-Original Message-
From: Ken Menzel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 3:25 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: FreeBSD issues
, and
has the above mentioned problem been resolved?
Regards,
Michael Caplan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Hi,
I am trying to install the latest distribution of mysql on a win 2000
box. The install program returns the following error each time:
"An error occurred during the move data process -132"
I noticed that someone else has brought up the same problem in the
past on this list. I'm very curiou
13 matches
Mail list logo