sqlite导出sql，导入mysql

安装sqlite
官网下载https://www.sqlite.org/download.html

分别解压，都放到E:\sqlite
将E:\sqlite降到系统环境变量
sqlite导出sql
doc.sqlite文件放在D:\grfood126\Desktop

C:\Users\grfood126>d:
D:\>cd grfood126\Desktop
D:\grfood126\Desktop>sqlite3
SQLite version 3.29.0 2019-07-10 17:32:03
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .open doc.sqlite
sqlite> .tables //查看有什么表
tb_company  tb_dir      tb_file     tb_key      tb_user
sqlite> .output company.sql //导出sql
sqlite> .dump tb_company
sqlite> .exit

sql修改sqlite语句，改为兼容mysql
删除：
"
BEGIN TRANSACTION
COMMIT
修改：
autoincrement -> auto_increment