[问题] sql问题?

楼主: pucca978 (pucca978)   2020-02-24 15:32:02
想请问前辈们 是我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
作者: LZN (秋)   2020-02-24 15:54:00
EXISTS ?
作者: justoncetime (台北丛林好冷~)   2020-02-24 16:26:00
先用sqlite命令列,或是管理工具如dbeaver确认SQL指令正确性,可以逐步限缩范围。除错过程也会有收获
作者: Schottky (顺风相送)   2020-02-24 19:31:00
就拼错字

Links booklink

Contact Us: admin [ a t ] ucptt.com