Recently in the laboratory equipment management system, before using the SQLite database, because it is the network version, replaced MySQL database, a large number of data manually knocked into too slow, there is no way to import it?
Here I did not dig deep, just completed their own task, I first of all, the SQLite database in the field in the Heidisql to establish a good.
The two most commonly used methods on the Web are implemented by exporting SQL and exporting CSV, where data transfer via CSV is attempted.
SQLite tools I use the SQLiteStudio2.1.5 http://sqlitestudio.pl/?act=download
MySQL I used the HeidiSQL8.3 http://www.heidisql.com/download.php
Sqlitestudio Open database file, find table, right-click menu has export table function, default all options, export SQL
After the table is selected in the Heidisql, the Tools menu has the Import SQL script file feature, the other default options, and then all the statements that create the database fields are deleted, leaving only the database statements that insert the data.
can be run.
Easy to import SQLite data into MySQL library