执行python时报错SyntaxError: Non-UTF-8 code

执行python时报错SyntaxError: Non-UTF-8 code starting with ‘\xb4’ in file sqlite_insert.py on line 3, but no encoding declared; see http://python.org/dev/peps/pep-0263/ for details

通过对文件增加编码格式进行解决。

coding=utf-8

coding=utf-8

import sqlite3

创建到数据库的连接

conn = sqlite3.connect(‘example.db’)

创建一个游标对象

cursor = conn.cursor()

插入数据的SQL语句

insert_data_sql = ‘’’
INSERT INTO students (name, age) VALUES (‘Alice’, 20), (‘Bob’, 22), (‘Charlie’, 23)
‘’’

执行SQL语句

cursor.execute(insert_data_sql)

提交更改并关闭连接

conn.commit()
conn.close()

执行无报错