Simple import of SQLite data into Mysql database, sqlite data into mysql

Simple import of SQLite data into Mysql database, sqlite data into mysql

Recently, I was working on a laboratory equipment management system. I used SQLite databases. Because they are online, I changed them to Mysql databases. It is too slow to manually import a large amount of data, is there any import method?
I did not dig deep here, but completed my own task. I first set up the fields in the sqlite database in HeidiSQL.
The two most common methods on the Internet are SQL export and csv export. Here we try to use CSV to transfer data.
SQLite tool I use SQLiteStudio2.1.5 http://sqlitestudio.pl /? Act = download
Mysql I use the HeidiSQL8.3 http://www.heidisql.com/download.php

SQLiteStudio open the database file, find the table, right-click the menu to export the table, all the default options, export SQL
After selecting a table in HeidiSQL, You can import the SQL script file in the tool menu. For other default options, delete all statements for creating database fields, leaving only the database statements for data insertion,
Run.