Trying to add a POLYGON using GeomFromText? I don't know about you, but although it's documented as being able to "construct a geometry value of any type", I'm getting NULLs returned.
Ex:
Select GeomFromText('POLYGON((0 0, 0 200, 200 200, 0 0))');
NULL
By narrowing down to the PolygonFromText function – we get some results:
Select PolygonFromText('POLYGON((0 0, 0 200, 200 200, 0 0))')
Binary value returned
This might seem obvious – but almost every tutorial / example I've seen suggest the use of GeomFromText. It may be the version of MySQL that I'm running, but I thought I'd share.