vendredi 23 janvier 2015

SQLite export specific content to *.sql file (automatical)

I need a solution to extract information from a sqlite .db file, it contains a whole database with multiple tables



Create TABLE table1(_id INTEGER PRIMARY KEY AUTOINCREMET, text TEXT UNIQUE)...
INSERT INTO table 1 (text) VALUES ("thetext")...


im having a MySQL Server, so i only need the data of a specific file of the .db, as a SQL file with just the INSERT INTO from a specific table.


What possibilities i have to get the result automatically, like by a batch or something


For INFO: File always has the same structure...


Aucun commentaire:

Enregistrer un commentaire