use subquery between mysql database and sql database

[blackhorse]

Such as

INSERT INTO database1.tb1 (field1, field2)
SELECT field1, field2 FROM database2.tb1

I could do the above query between two mysql database, if I use the same user and password to access these two mysql database.

Could I do it if database1 is sqlite3 database, database2 is mysql database?

Thanks!

[ixalmida]

If you set up both databases as ODBC data sources you may be able to pull data together into a single ODBC query.

[Sxooter]

blackhorse;10936070 wrote:

Such as

INSERT INTO database1.tb1 (field1, field2)
SELECT field1, field2 FROM database2.tb1

I could do the above query between two mysql database, if I use the same user and password to access these two mysql database.

Could I do it if database1 is sqlite3 database, database2 is mysql database?

Thanks!

Probably not. PostgreSQL has a contrib module called dbilink that uses pl/perl to allow such things (you can connect to oracle, sqlserver etc.) but I'm not sure even that would work as sqllite isn't really a full blown db engine.

Easiest way is to import the data into a temp table in mysql then run the query.

[blackhorse]

Thanks!

The data is not very much, a few thousands rows (all tables) or so.

I can just select all rows from mysql and then insert one row by one row to sqlite3 in a loop.