qq_45911550的博客

# Author: Lu Daze# Creatation date: 2020.3.2# Last modification date: 2020.3.2# Function description: Using python to create a database with sqlite3, and merge different tables according to the same data with the method of 'JOIN'import sqlite3conn_inf

1、链接数据库import sqlite3conn = sqlite3.connect('python_test.db')c = conn.cursor()print ("Opened database successfully")c.execute("INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) \ VALUES (1, 'Paul', 32, 'California', 20000.00 )")c.execute("INS

1、创建数据库$sqlite3 DatabaseName.db或者sqlite>.open test.db2、查看sqlite>.databases3、退出sqlite>.quit4、将数据库中的内容导出到文本中$sqlite3 testDB.db .dump > testDB.sqltestDB.db 数据库的内容导出到testDB.sql中5、从文本到数据库的恢复$sqlite3 testDB.db < testDB.sql6、创建表

因为要使用python开发app需要使用sqlite，这里记录一下操作。命令如下：sudo apt updatesudo apt-cache search sqlitesudo apt install sqlite3sudo apt install sqlite3sudo apt updatesudo apt install sqlitebrowser查看版本sqlitebrowser –version装玩之后该有图形化界面的；...