SQL: How to update with select a spatial value ?

2005-06-11 Thread 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

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

2005-05-29 Thread 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

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

2005-03-01 Thread 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

Which version for fastest simple inserts, selects etc

2005-02-22 Thread 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: