01/10/2018, 01:11
Giúp em lỗi sqlite3!
import sqlite3
conn = sqlite3.connect(‘tutorial.db’)
c = conn.cursor()
def create_table():
c.execute(‘CREATE TABLE IF NOT EXISTS stuffToPlot(unix REAL,datestamp TEXT, keyword TEXT, value REAL)’)
def data_entry():
c.execute(“INSERT INFO stuffToPlot VALUES(145123542,‘2016-01-01’,‘Python’,5)”)
conn.commit()
c.close()
conn.close()
create_table()
data_entry()
Traceback (most recent call last):
File “E:pythonSQLiteSQL.py”, line 16, in
data_entry()
File “E:pythonSQLiteSQL.py”, line 10, in data_entry
c.execute(“INSERT INFO stuffToPlot VALUES(145123542,‘2016-01-01’,‘Python’,5)”)
sqlite3.OperationalError: near “INFO”: syntax error
em bị lỗi gì v ạ ??
Bài liên quan
INSERT INFO là câu lệnh gì thế? :v
haiz làm từ sáng giờ kiếm k ra :v tks bác