I am trying to create a database using sqlite in python within my tkinter application - I was following a tutorial which i have used before and typed the text correctly as he had however I keep receiving an error I cannot solve - the code is below.
the error is: c.execute("""CREATE TABLE jobdata ( sqlite3.OperationalError: near ")": syntax error
import tkinter as tk
from tkinter import ttk
from tkinter import *
import sqlite3
LARGEFONT =("Verdana", 35)
conn = sqlite3.connect('jobtracker.db')
c = conn.cursor()
c.execute("""CREATE TABLE jobdata (
company text,
role text,
industry text,
location text,
wage integer,
start_date integer,
)""")
conn.commit()
conn.close()
I have placed this at the top of my code above my classes I have built for my GUI - I can post the rest of the code if need be. I have gone over the syntax so many times and found it no different to how the tutorial had written it. Any help would be greatly appreciated!
Thanks!
)in the SQL statement:..., start_date integer,). Remove it.