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 _neg
... 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]
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-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
T
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 recor
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 ... O
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 upgra
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
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 arch
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 <
me
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
> 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
12 matches
Mail list logo
