I have seen that but I am stuck at just populating my POLYGON column (poly). I have tried this:
UPDATE `grid` SET poly = PolygonFromText('POLYGON(`n` `e`, `s` `e`, `s` `w`, `n` `w`, `n` `e`)'); but my poly column just reports back NULL. the n, e, s & w columns are decimal lat / long data. Dan On Sun, 2 May 2010 06:43:13 -0700, Ted Yu <yuzhih...@gmail.com> wrote: > I think you may have seen this: > http://dev.mysql.com/doc/refman/5.0/en/relations-on-geometry-mbr.html > > On Sat, May 1, 2010 at 11:12 PM, dan <d...@tappin.ca> wrote: > >> >> Can any one help me with understanding the mysql spatial functions? I >> can >> only seem to find bits and pieces of how-to's etc. >> >> I have an existing table of lat / long data representing unique >> boundaries >> i.e. rectangles and I want to search the table to find the rectangle that >> bounds a specific point. >> >> Dan >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/mysql?unsub=yuzhih...@gmail.com >> >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org