SQL: How to update with select a spatial value ?

[Pete Lancashire]

I have an existing MyISAM table that I want to add a spatial column
to. It originally had two integer columns, lat and lon, and I've
added a new column location point NOT NULL default ''

Example data:

  select lat, lon, astext(location) from fooloc;
  +--+--+--+
  | lat  | lon  | astext(location) |
  +--+--+--+
  |0 |0 | NULL |
  |   10 |  -10 | NULL |
  |1 |5 | NULL |
  +--+--+--+

Lon and Lat have values, I'm trying to come up with a UPDATE
for the column location that will do something like:

  update fooloc set location = geomfromtext('point(lat lon)');

Is there a way to do this with a single update ?

tia

-pete



  


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

load data infile. Empty input field - integer. How make NULL ?

[Pete Lancashire]

I've been surfing the list / google but can't find what to do

I have a tab sep file, where there are empty fields i.e.
tabtab

the fields are associated with a mysql table integer type.

how do I get the empty fields to become NULL instead of
0 (zero) with a warning ?

Thanks,

-pete


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Parallel Mysql Was: Re: Innodb and Linux 2.6 Async I/O ??

[Pete Lancashire]

To me what is more important is where this is leading,

http://www.distlab.dk/badger/Publications/exec_summary.pdf

a true parallel database cluster, with the end goal of this
work being a parallel MySQL.

My cluster waits ..

-pete



On Mon, 2005-02-28 at 14:04, Greg Whalin wrote:
 Just found and read this study: 
 http://www.distlab.dk/badger/Publications/report0403.ps
 
 and was curious to see if anyone has any additional thoughts as to the 
 contents?
 
 Greg


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Which version for fastest simple inserts, selects etc

[Pete Lancashire]

If I needed a brute force DB on an x86 platform would
using Version 3 vs 4 buy me any performance today ?

90% inserts, 5% simple selects, 5% other.

Sorry if a lame question

-pete


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]