想請問前輩們 是我sql沒導入 還是哪邊有問題啊?
import sqlite3
conn=sqlite3.connect('test.sqlite')
cursor=conn.cursor()
abc='CREATE TABLE IF NOT EXITS table01 \ <=若把\拿掉變成錯誤2
("num" INTEGER PRIMARY KEY NOT NULL,"tel" TEXT)'
ace='insert into table01 values(1,"03-1234567")'
cursor.execute(abc)
cursor.execute(ace)
conn.commit()
conn.close()
OperationalError: near "EXITS": syntax error -錯誤1
SyntaxError: EOL while scanning string literal -錯誤2