How can I create a database using SQLite3 in python 3 for mac?

Question

So far this is the code I have and I keep getting an error stating: "sqlite3.OperationalError: near ")": syntax error"

import sqlite3
con = sqlite3.connect("DatabaseName.sql")

cur = con.cursor()

cur.execute("""CREATE TABLE Contacts (Fname TEXT,
Lname TEXT, Phone INTEGER,)""")

Fname = input("Enter first name: ")
Lname = input("Enter last name: ")
Phone = input("Enter telephone number(no dashes or spaces): ")
Phone = int(Phone)


cur.execute("""INSERT INTO Contacts (Fname, Lname, Phone, joined_club)
VALUES (?,?,?)""", (Fname,Lname,Phone))

con.commit()

cur.close()
con.close()

Brian Campbell · Accepted Answer · 2012-11-21 06:43:30Z

4

You have an extra comma in your create statement, before the close paren. It should be:

cur.execute("""CREATE TABLE Contacts (Fname TEXT,
Lname TEXT, Phone INTEGER)""")

Later on, you have an extra parameter, joined_club, in your INSERT statement. It should be:

cur.execute("""INSERT INTO Contacts (Fname, Lname, Phone)
VALUES (?,?,?)""", (Fname,Lname,Phone))

edited Nov 21, 2012 at 6:43

answered Nov 21, 2012 at 5:20

Brian Campbell

335k59 gold badges367 silver badges344 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I create a database using SQLite3 in python 3 for mac?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related