]
Regards,
Jeremy
Nick Hill wrote:
Is there an easy way to build MySQL client library, server and
start-up script so that /etc/my.cnf is ignored?
I need to build client and server so that it in no way interacts with
the global system install, and build programs against that client
library which
Is there an easy way to build MySQL client library, server and start-up script
so that /etc/my.cnf is ignored?
I need to build client and server so that it in no way interacts with the global
system install, and build programs against that client library which also don't
interact with the glob
Hello John
There are two approaches to this.
1) Best, save date into table as a number. Select date like
WHERE date>=$date1 AND date<=$date2
2)Otherwise, if storing dates a strings:
WHERE date=$date1 OR date=$date2 OR date=$date3 OR date=$date4 OR
date=$date5.
In general, if you want to
Hello Adam
Adam Wolff wrote:
Actually runs through the table four times instead of twice, and maybe
can't even use the index for the whole query.
Assuming my results are not typical of MySQL query times, this would
explain the sqrt() relationship of returned rows to query time.
I have tried
Alexey Polyakov wrote:
On 4/23/06, Nick Hill <[EMAIL PROTECTED]> wrote:
I've noticed a couple things.
1) Right now you're emulating spatial index.
2) In future, you're going to emulate partitioning.
Why do you think that doing this stuff manually is better than using
buil
Hello
I have been looking at planning the database strategy for openstreetmap
(http://www.openstreetmap.org).
There are several data types stored in tables with longitude and
latitude columns. Select statements work by selecting
where lat>$lat1 and lat<$lat2 and lon>$lon1 and lon<$lon2
I h
