Deva,
hmm... this is mysterious. This might also be an OS bug. If you have the
.err log from other crashes, please send it to [EMAIL PROTECTED]
Best regards,
Heikki Tuuri
Vice President, server technology
Oracle Corp.
- Original Message -
From: "Devananda" <[EMAIL PROTECTED]>
Newsg
At 6:26 +0200 10/9/05, liofr wrote:
HI
where i can find documentation about decode the binary informations
of the Geometry columns in mysql using C ?
for example
mysql doc say that
0x010100F03FF03F
is equivalent to
Point(1 1)
Presumably you are looking at:
http://
If you are using a version of MySQL that supports subqueries, you can do
something like this:
select * from unprocessed_url_table
where url not in (select url from processed_url_table)
In other words, the inner query (the part in brackets) is returning a list
of all the URLs that have been proces
HI
where i can find documentation about decode the binary informations of
the Geometry columns in mysql using C ?
for example
mysql doc say that
0x010100F03FF03F
is equivalent to
Point(1 1)
Thank's
--
MySQL General Mailing List
For list archives: http://lists.mysql
Ok. I think I have what I need... Almost. Here is the query I settled on:
SELECT b.zip, b.state,b.storename,
(3956 * (2 * ASIN(SQRT(
POWER(SIN(((a.lat-b.lat)*0.017453293)/2),2) +
COS(a.lat*0.017453293) *
COS(b.lat*0.017453293) *
I saw those and several on finding matches and are close but the problem I
ran into is that yeah.. they find all of the zips within the specified
radius but I need to the matches that came from another table.
Thanks
Steffan
---
T E L
i have two tables one of them is a que of urls and the other is list
of urls that have been processed
now i want to select a url from Que that is not in the processed urls
table how can i do this in one select i do not want my application to
do two seperate select statements?
thx..
Nurul
At 05:59 PM 10/8/2005, you wrote:
I was wondering if anyone might have a canned query I could use for the
following scenario.
I need to search for a list of locations within a certain distance of a user
given zip code and order them by driving distance calculated from a table of
zip codes contai
At 12:50 PM 10/8/2005, you wrote:
Paul DuBois wrote:
At 10:11 -0700 10/8/05, Bruce Ferrell wrote:
Hi All,
I'm bulkloading my instance and I'm getting a return message at the end
of the load like this:
mysql> \. vm_load.txt
Query OK, 164 rows affected, 113 warnings (0.01 sec)
Records: 164
I'm working on a PHP script which will already have gathered a large
array of string values from a text file. These values will correspond
to item numbers in a MySQL table. What I need to do is select rows in
the table based on whether or not their "item_number" values are in
the pre-existi
I was wondering if anyone might have a canned query I could use for the
following scenario.
I need to search for a list of locations within a certain distance of a user
given zip code and order them by driving distance calculated from a table of
zip codes containing lon and lat info from zipwise.
Paul DuBois wrote:
At 10:11 -0700 10/8/05, Bruce Ferrell wrote:
Hi All,
I'm bulkloading my instance and I'm getting a return message at the
end of the load like this:
mysql> \. vm_load.txt
Query OK, 164 rows affected, 113 warnings (0.01 sec)
Records: 164 Duplicates: 0 Warnings: 113
When
At 10:11 -0700 10/8/05, Bruce Ferrell wrote:
Hi All,
I'm bulkloading my instance and I'm getting a return message at the
end of the load like this:
mysql> \. vm_load.txt
Query OK, 164 rows affected, 113 warnings (0.01 sec)
Records: 164 Duplicates: 0 Warnings: 113
When I load the data line
Hi All,
I'm bulkloading my instance and I'm getting a return message at the end
of the load like this:
mysql> \. vm_load.txt
Query OK, 164 rows affected, 113 warnings (0.01 sec)
Records: 164 Duplicates: 0 Warnings: 113
When I load the data line by line, I get no warnings.
How can I see wha
Hello.
Search in the archives at:
http://lists.mysql.com/mysql
BETWEEN is meant among other operators at:
http://dev.mysql.com/doc/mysql/en/using-date.html
But be aware of that when you're using a datetime columns the query:
SELECT a from b WHERE a BETWEEN '2005-01-01' and '2005
Hello.
> select t1.date, t1.val, t2.val from t1
> right join t2 on t1.date = t2.date
> where t1.date between '2005-08-01' and '2005-08-14'
> and t1.uid = 'me';
Maybe it is better to move a condition on t1 fields from
WHERE to ON part of the query? Or I don't see any sense
in using a RIGH
Hello.
> BEGIN;
> SELECT id FROM ttt WHERE id=3D7 FOR UPDATE;
> INSERT INTO ttt(id) VALUES (7);
> DELETE FROM ttt WHERE id=3D7;
> COMMIT;
Maybe we have this scenario:
A, B - transactions.
A -> SELECT ... FOR UPDATE - is setting an X lock on index for id=8
(next key locking, it is
Hello.
See:
http://dev.mysql.com/doc/mysql/en/not-enough-file-handles.html
Ian Collins wrote:
> Hi,
> I am running an application using the C-API against mysql 4.0.20 on a
> redhat AS 3 server.
>
> The users using this application are getting numerous (and seemingly
> random) query
18 matches
Mail list logo
