SQL / Python Create Table Error

Question

I am getting a strange error when I am trying to create this table.... When I track it back I have nothing on line 5? Can anyone help me on how to track this error?

import settings import mysql.connector from database import login_info import datetime as dt

def main():
    db = mysql.connector.Connect(**login_info)
    cursor = db.cursor()
    sql =('DROP TABLE IF EXISTS messages')
    cursor.execute(sql)
    db.commit()

message_table = """\
    CREATE TABLE messages(
        msgID INTEGER AUTO_INCREMENT PRIMARY KEY,
        message VARCHAR(500) DEFAULT NULL,
        subject VARCHAR(500) DEFAULT NULL,
       )"""
cursor.execute(message_table)
db.commit()

Error == mysql.connector.errors.ProgrammingError: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 5

I can connect ot SQl in an interactive window no problem.

You may have a further problem after the one you're currently experiencing due to the brackets round ('DROP TABLE IF EXISTS messages') — George
– George, Commented Mar 13, 2013 at 16:01
Syntax error: The comma after the last field definition. The comma is meant to separate the elements of the definition of the table (fields, indexes, etc)... Please always remember to check the documentation (in this case, MySQL documentation: Data Definition Statements: CREATE). The error message even gives you a good hint about where the error is. — Barranka
– Barranka, Commented Mar 13, 2013 at 16:38

Klas Lindbäck · Accepted Answer · 2013-03-13 15:56:56Z

1

Try removing the , at the end of line 4.

answered Mar 13, 2013 at 15:56

Klas Lindbäck

33.4k5 gold badges61 silver badges85 bronze badges

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

1 Comment

Klas Lindbäck Over a year ago

After the last NULL. I don't think you are permitted to have a trailing , after the last field declaration.

Collectives™ on Stack Overflow

SQL / Python Create Table Error

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related