I want to import data from MySQL DB. MySQL schema has a lot of tables with a huge amount of data. This is non spatial data. I want to import objects as vector layers using sql query which is selecting and joining only what I need. Is it possible to do?
I`ve tried to use Layer->Add Vector Layer ...> MySQL database. But QGIS get crashed in this case (Import MySQL data to QGIS with a plugin). Indeed, my db has not vector data, it has only tables with longitude, latitude columns.
I`ve tried to use DB Manager plugin but its help says that only four predefined dbms backends are supported (db_manager github) and no MySQL DBMS listed there.