Plz Help in OGR and MYSQL

Frank Warmerdam warmerdam at POBOX.COM
Thu May 4 06:04:31 PDT 2006


grabiel wrote:
>         connectiontype ogr
>         connection "n_state.shp"
>         DATA "SELECT * from nsdata left join 'MYSQL:test,   
>     host=localhost, user=root'.nsdata ON n_state.st_nm=nsdata.name"
>  END
> END
>

Grabriel,

I think you want:

SELECT * from n_state LEFT JOIN ...

The n_state player (from the shapefile) is the primary table.

You should be able to test the left join from ogrinfo as well using
the -sql command option.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | President OSGF, http://osgeo.org



More information about the MapServer-users mailing list