[GRASS-user] How to JOIN a table to vector layer using MySQL

Jarek Jasiewicz jarekj at amu.edu.pl
Wed Nov 8 15:33:08 EST 2006


Nicolas Devaux napisał(a):
> Hi, I'm using Grass 6.0 (I will use 6.2 soon, but I need to go further 
> with 6.0 version until one month).
> I would like to join a vector table with external attribute table 
> using MySQL.
> I created the MySQL Database, and did the v.dbconnect with MySQL drivers.
> I did the Join operation with Mysql and it works perfectly. But, when 
> I come back in Grass, it is not possible to see the result within the 
> attribute table... Joined attributes are not in the table. It seems 
> that grass is not able to see results of the joined operation made in 
> Mysql.
>
> Does some body has any suggestion ?
>
> To resume my problem, I can say that I just try to do a join operation 
> on vector attribute table, and that this operation seems to be a 
> little bit difficult with Grass.
>
> Thanks
>
> --------------------------------------------------------
>
> _______________________________________________
> grassuser mailing list
> grassuser at grass.itc.it
> http://grass.itc.it/mailman/listinfo/grassuser
well grass not see joined tables. the only way as I thing is to use SQL 
command CREATE TABLE nova AS
SELECT a.cat ..... FROM a INNER JOIN b ON .......;
nad reconnect vector to nova table (a.cat MUST be in SELECT section)
I use it very ofen but... on PgSQL. I'm not sure if CRATE TABLE AS works 
on mysql

regards
Jarek




More information about the grass-user mailing list