为什么无法这样给sqlite传参

Question

login_id = self.getusername.get()
print(login_id)

    conn = sqlite3.connect("D:\\data.db")
    cur = conn.execute("create table if not exists "+login_id+"(UID varchar(128) primary key,phone varchar(128), QQ varchar(128),address varchar(125));")
    hel[1].commit()
    hel[1].close()

Answer 1

肯定不能啊，你这样传相当于把一个语句分割成几节字符串了，要么用占位符%s 要么用.format