<div dir="ltr">Hi Walter,<div> MySQL has very weak Spatial capabilities. And the comment on the answer of this question - <a href="http://stackoverflow.com/questions/14139462/mysql-connection-in-qgis">http://stackoverflow.com/questions/14139462/mysql-connection-in-qgis</a> - suggests that support within QGIS diminished in 2.0.</div>
<div><br></div><div>It may be worth converting your data to a different format. If you want a database, either PostGIS or SpatiaLite would be good picks with excellent spatial capabilities, both well supported by QGIS too.</div>
<div><br></div><div>Cheers,</div><div>Jonathan</div><div class="gmail_extra"><div><br></div>
<br><br><div class="gmail_quote">On 9 June 2014 16:44, Walter Zupa <span dir="ltr"><<a href="mailto:zupa@coispa.it" target="_blank">zupa@coispa.it</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<p>I have a MySQL DB in which tables there are fishery data linked
to a grid previously generated.<br>
The aim, for me, is to use updated data, stored in mysql db,
geo-referring them to the codes of the cells of a given grid.<br>
Importing in Qgis the tables as vectors, directly from the mySQL
DB, I obtain tables. On this tables, I can't understand why, I'm
not able to apply the query, using the filter tool.</p>
<p>The filter doesn't work also when I join the given grid to the
table data, using the cells codes.</p>
<p>Giving an example, the filter used on the species column,
recognized all the different factors in the field but the result
of the the query is empty: Zero rows are selected.<br>
How can I successfully use MySQL table as data souce in QGIS?</p>
<p>I tried also to use the XY tool in order to transform the table
in a shapefile, but also this solution seems not to work.</p>
<p>Could someone help me??</p>
<p>Walter</p>
<div>-- <br>
<div> <small><b>Walter Zupa</b></small><br>
<pre style="color:rgb(19,185,45);text-align:justify"><span style="font-size:small">Rispetta l'ambiente: se non è necessario, non stampare questo documento o usa carta da riciclo.
Per risparmiare toner delle stampanti vi consigliamo l'utilizzo dell' ECO FONT
che risparmia il 30% di inchiostro. L' ECO-FONT è scaricabile gratuitamente dal sito <a href="http://www.ecofont.eu" target="_blank">www.ecofont.eu</a></span></pre>
<p><span style="font-size:x-small"><strong><span style="text-decoration:underline">Avviso di
riservatezza</span></strong></span></p>
<p><span style="font-size:x-small"><em>Questo messaggio e-mail
è ad uso esclusivo di colui al quale è indirizzato, e
potrebbe contenere informazioni riservate. Se aveste
ricevuto questo messaggio per errore, ci scusiamo per
l’accaduto e Vi invitiamo cortesemente a darcene notizia e
a distruggere il messaggio ricevuto. Vi ricordiamo che la
diffusione,l’utilizzo e/o la conservazione dei dati
ricevuti per errore costituiscono violazioni alle
disposizioni del Decreto legislativo n. 196/2003
denominato “Codice in materia di protezione dei dati
personali”.</em></span></p>
<p><span style="font-size:x-small"><em><br>
</em><em>The information in this email is intended only for
the person(s) or entity to whom it is addressed and may
contain confidential or privileged information. If you are
not the intended recipient, please notify the sender
immediately and destroy it. We remember you that the
diffusion, the use and or the maintenance of the data
received for error may constitute violations to the
dispositions of the legislative Decree n. 196/2003
denominated “Code in subject of protection of personal
data".</em></span></p>
</div>
</div>
</div>
<br>_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></blockquote></div><br></div></div>
<br>
<span style="color:rgb(34,34,34);font-family:Arial;background-color:rgb(255,255,255)">This transmission is intended for the named addressee(s) only and may contain confidential, sensitive or personal information and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.</span>