Anyone know whats wrong here?
Try as
...
From (Klienter AS K, Tid As Td, Personal AS P)
JOIN Uppdrag AS U ON K.Klient_ID = U.Klient_ID
...
or
...
From Tid As Td, Personal AS P, Klienter AS K
JOIN Uppdrag AS U ON K.Klient_ID = U.Klient_ID
...
This is the problem I had in one of my queries.
mysqlcheck -h$host -u$user -p$pass --analyze $dbname
I wish that was the case!
I tried analyze table ... and optimize table ..., which I presume
would be the same. It did not help. I also ran mysqlcheck just to see
if it will make a difference. Nope!
--
MySQL General Mailing List
For list
I hope someone can clue me in what a syntax of query that produces the
same would look like for MySQL 5.0.12
Old query meant to list most recent message from each thread, e.g.
select * from messages left join messages as messages_ on
messages.thread = messages_.thread and messages.created
It worked in 4.x but does not work in the new syntax. How should I
rewrite it to get the same result?
OK, that was a lie. It works in 5.x as well. I should learn to
describe my problem more accurately as well as RTFM :-(
The correct description of the query in question would have been:
select
I had perfectly working complex queries both with LEFT JOIN and without
and they were returning results in under a second. After upgrade to
5.0.x, the same queries would return results in 20-30 second range.
Through trial and error, I discovered that in case of SELECT ... FROM
table1, table2 ...
possible you had set up some query cache in 4, but not currently in 5?
may not be optimized, but yes, query cache is enabled, all 25 MB of it. :-)
how did you 'upgraded' your data?
regrettably, in-place.
interestingly, I was recovering after server crash that chopped of a
table. after
When you upgraded from 4.1 to 5.0, did you do an in-place upgrade, or mysqldump
your data and then re-import?
As replied to Sebastian's post, in-place.
Try using either mysqldump or mysql-administrator to dump out your data to an
.sql file. Then re-import all of your data into 5.x. You will
On Tue, 2006-08-29 at 16:30 -0400, Jesse wrote:
Does anyone have any ideas?
One technique is to calculate set distances (5,10,25,50) between the zip
codes in advance and stick the results in a table.
Enjoy,
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On Thu, 2006-07-06 at 13:41 -0700, Chuck Holzwarth wrote:
Is there a way to set the auto_increment start number? I
am trying to set up a development and test system and the
application that is writing to the tables is confused as
to which MySQL it is writing to. I don't have any contrtol
On Tue, 2006-04-25 at 00:43 -0700, Daevid Vincent wrote:
So for a sanity check, I decided to look online and punch in some to see
what the real lat/long should be. Well, different sites give different
values, and not only are they slightly off, but sometimes they're
_positive_ or _negative_!?
... err, as would be South...
N+, S-, E+, W-
Ed :-)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I am stomped and not sure how to get results from the particular type of
query. While I am not sure, if this is an appropriate place to ask, if
nothing else perhaps someone will direct me to a more appropriate forum.
I am trying to figure out how to return the latest record in each group
of
12 matches
Mail list logo