Re: temporary table issue

Ben Clewett wrote: But the index does not seem nearly as fast as liner (normal) indexes. Hence using a less effective liner index may be better... After this method I still need select a radius within these data points, more effort. This could be an excellent case for using HAVING The WHER

Re: temporary table issue

Thanks for the excellent advise. In the mean while a friend Googled me an article suggesting that this can be done using the POINT and SPATIAL INDEX. But I prefer your ideas. I'll show what I found because I want to see if anybody has an opinion on problems with either method: Here I Store

Re: temporary table issue

Hi, Jigal Thanks a lot. It works. > Xiaobo Chen wrote: >> Hi, all >> >> I am trying to use this with error: >> >> drop temporary tabel temp_a if exists 'temp_a'; >> >> it said syntax error. > > Try: > > DROP TEMPORARY TABLE IF EXISTS `temp_a`; > > ('table' instead of 'tabel'; table name only once

Re: temporary table issue

DROP TEMPORARY TABLE IF EXISTS `temp_a`; Xiaobo Chen wrote: Hi, all I am trying to use this with error: drop temporary tabel temp_a if exists 'temp_a'; it said syntax error. Could anybody tell me the right syntax? I didn't find the answer after googling a while. Thanks in advance. Xiaob

Re: temporary table issue

Xiaobo Chen wrote: Hi, all I am trying to use this with error: drop temporary tabel temp_a if exists 'temp_a'; it said syntax error. Try: DROP TEMPORARY TABLE IF EXISTS `temp_a`; ('table' instead of 'tabel'; table name only once; backticks around table name instead of quotes) http://dev

temporary table issue

Hi, all I am trying to use this with error: drop temporary tabel temp_a if exists 'temp_a'; it said syntax error. Could anybody tell me the right syntax? I didn't find the answer after googling a while. Thanks in advance. Xiaobo -- Faculty of Computer Science Dalhousie University Halifax, No