Re: New tutorial: reading polylines from a MySQL database

Mike,

In postgres, when you do this you need to convert the values into a
polygon type, so I expect that something similar is required for MySql.
Just a glance at the MySql documentation reveals this:

Polygon(ls1,ls2,...)

So... I'm guessing that the correct syntax should be something like:
INSERT INTO track( geometry ) VALUES (
Polygon('
(-122.00337.274,-121.99937.272),(-121.99037.206,...),(...,...)') ) ;

Or something along those lines. The idea is you have to have the
correct type of value to pass it to a geometric field type.

-John

http://maps.huge.info