Hi Douglas,
Douglas Pearson wrote:
Sorry if this is a dumb question, but are SQL transactions in MySQL atomic?
I'm using InnoDB tables in MySQL5.
Clearly, transactions have the property that either all updates occur or
none do. By atomic, I mean are other queries guaranteed to either see all
c
Sorry if this is a dumb question, but are SQL transactions in MySQL atomic?
I'm using InnoDB tables in MySQL5.
Clearly, transactions have the property that either all updates occur or
none do. By atomic, I mean are other queries guaranteed to either see all
changes from the transaction or none of
> Hello
> where is the FROM for f1 table?
> Martin--
Why would there be any "FROM" for the f1 table? It's not needed in the result.
Anyway, I've come up with a query that actually seems to do what I'm looking
for;
SELECT a1.username FROM accountuser AS a1
LEFT JOIN payments AS p1 ON (a1.userna
Wagner,
SHOW PROFILE[S] is documented at
http://dev.mysql.com/doc/refman/5.0/en/show-profiles.html.
5.0 Community edition only. Perhaps it will appear in 5.1 Community?
They do not say so.
PB
Wagner Bianchi wrote:
Hi friends,
Somebody here in this list have or knows where i get or read a
Hi friends,
Somebody here in this list have or knows where i get or read about the PROFILE
of MySQL (SHOW PROFILE) ?
I see this article of Schummi, but is most superficial.
(http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html)
Can u help me?
Thk's 4 all.
Wagner Bianchi
Anders Norrbring wrote:
I'm trying to set up a query, but I don't really get the result I
expected, so can someone please help me out here?
The query I've built is this:
SELECT a1.username FROM accountuser AS a1
LEFT JOIN (freeaccounts AS f1, payments AS p1)
ON (a1.username = p1.username
AND p
I'm trying to set up a query, but I don't really get the result I
expected, so can someone please help me out here?
The query I've built is this:
SELECT a1.username FROM accountuser AS a1
LEFT JOIN (freeaccounts AS f1, payments AS p1)
ON (a1.username = p1.username
AND p1.username = f1.username)
