Python 3.7.0 (v3.7.0:1bf9cc5093, Jun 27 2018, 04:59:51) [MSC v.1914 64 bit (AMD64)] on win32
Type “help”, “copyright”, “credits” or “license” for more information.
help
Type help() for interactive help, or help(object) for help about object.import sqlite3
print(sqlite3.version_info) #显示sqlite3版本信息
(2, 6, 0)
print(sqlite3.sqlite_version) #显示SQLite版本信息
3.21.0
exit()
升级后
Python 3.7.0 (v3.7.0:1bf9cc5093, Jun 27 2018, 04:59:51) [MSC v.1914 64 bit (AMD64)] on win32
Type “help”, “copyright”, “credits” or “license” for more information.
import sqlite3
print(sqlite3.version_info) #显示sqlite3版本信息
(2, 6, 0)
print(sqlite3.sqlite_version) #显示SQLite版本信息
3.40.0
在线测试sqlite语法的网页:
INSERT INTO phonebook(name,phonenumber) VALUES(‘Alis’,’574-334-1212′)
ON CONFLICT(name) DO UPDATE SET phonenumber=excluded.phonenumber;
select * from phonebook
Original: https://blog.csdn.net/caozhenyu/article/details/128415005
Author: lmyc-film
Title: pycharm 中sqlite升级方法
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/815735/
转载文章受原作者版权保护。转载请注明原作者出处!