MySQL Forums
Forum List  »  GIS

Deleting spatial data only deletes one row
Posted by: Chris Ayers
Date: January 10, 2005 01:35PM

I have the following query that does not work correctly:
DELETE FROM terrain WHERE MBRContains(PolygonFromText('POLYGON((0 0, 1000 0, 1000 1000, 0 1000, 0 0))'),object)

object has a datatype of POLYGON.

The problem is that there are several rows that meet the WHERE clause of the delete statement, but only one row gets deleted (they all should!!). Any clues on to what I am doing wrong? TIA.

Options: ReplyQuote

Written By
Deleting spatial data only deletes one row
January 10, 2005 01:35PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.