Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
In SpatiaLite or Postgis, how can one create a SQL query to read a table from a MySql or Oracle database?
I don't know **the correct SQL syntax to connect to a table in a MySql or Oracle database **.
You may be able to do this in PostGIS by using Foreign Data Wrappers (FDW). There is one for Oracle and another that can wrap any OGR datasource (which should include MySQL).
I've never tried this (why would I store data outside PostGIS?) but this blog post suggests it is quite easy to use.
Required, but never shown