You can only access them using OGR in Mapserver. See also:
http://www.gdal.org/ogr/drv_mysql.html A better option would be PostGIS ofcourse. If you have the choice, go for that one. Best regards, Bart -----Oorspronkelijk bericht----- Van: UMN MapServer Users List [mailto:[EMAIL PROTECTED] Murat BEYHAN Verzonden: woensdag 4 oktober 2006 13:22 Aan: [email protected] Onderwerp: [UMN_MAPSERVER-USERS] MySql Spatial Database Dear Friends; Is it possible to connect mysql spatial database by using Mapserver 4.8.4 if it is? I would like to make a spatial database on MySql and add my data into database. I have polygon, line and pointdata. So I have found the followings in MySQL database to create spatial database table but I dont have any idea how can I insert polygon or line or point data into the table. If any idea to do this Please help. mysql> CREATE TABLE spat (p POINT, g POLYGON, l LINESTRING, geo GEOMETRY ); mysql> INSERT INTO spat (p) VALUES (GeomFromText('POINT(1 2)')); mysql> select X(p),Y(p) from spat; regards Murat -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. Disclaimer ************************************************************************ Aan dit bericht kunnen geen rechten worden ontleend. Dit bericht is uitsluitend bestemd voor de geadresseerde. Als u dit bericht per abuis hebt ontvangen, wordt u verzocht het te vernietigen en de afzender te informeren. Wij adviseren u om bij twijfel over de juistheid of de volledigheid van de mail contact met afzender op te nemen. This message shall not constitute any rights or obligations. This message is intended solely for the addressee. If you have received this message in error, please delete it and notify the sender immediately. When in doubt whether this message is correct or complete, please contact the sender. ************************************************************************
