MySQL data import to SQLite data

SQLite data is very convenient when doing the program. Steps to export to SQLite with MySQL data: (transition with CSV file)

-------------------------------pilot out to the CSV file-------------------------

1. Use navicat software to export MySQL data to TXT file.

2. Note Select Include column header (field name), column delimiter (CSV file with comma).

3. Convert all TXT files to utf-8 encoding.

4, write a rename.bat (ren *.txt *.csv), all unified renaming.

-------------------------------then import the-------------------------with a CSV file

5. Open a DB file with Sqlitemanager.

6. Select Import other files. Select the CSV file.

7. Select or enter the table you want to import in the table column.

8. Be careful to select "First row contains column names" (column name is included in section one)

9. Click Import.

10. Modify the properties of each field.