Why am I getting the operationalerror near 'VARCHAR' during SQL call in Python?

Question

I'm receiving 'OperationalError: near "VARCHAR": syntax error' when I call this function, what am I doing wrong?

def database_create_user(table_name, user_ID, username, password, creator_exp):
    users_db_curs.execute("INSERT INTO `" + table_name + "` (uID VARCHAR(20), username VARCHAR(20), password VARCHAR(30), creator_exp VARCHAR(20)) VALUES ('" + user_ID + "', '" + username + "', '" + password + "', '" + creator_exp + "')")
    users_db_connection.commit()

davesnitty · Accepted Answer · 2012-05-06 01:54:53Z

2

Once the table has already been created, you do not need to re-specify the column types in each INSERT query. You could just do:

users_db_curs.execute("INSERT INTO `" + table_name + "` (user_ID, username , password , creator_exp ) VALUES ('" + user_ID + "', '" + username + "', '" + password + "', '" + creator_exp + "')")

answered May 6, 2012 at 1:54

davesnitty

1,87016 silver badges11 bronze badges

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

Comments

user756519 · Accepted Answer · 2012-05-06 01:55:10Z

2

You shouldn't specify the data types in the INSERT statement. I have removed the data types that appeared in the INSERT statement. Here is the corrected version.

The code is wrapped here into multiple lines for clarity and readability.

def database_create_user(table_name, user_ID, username, password, creator_exp):
users_db_curs.execute("INSERT INTO `" + table_name + "` (uID, username, 
password, creator_exp) VALUES ('" + user_ID + "', '" + username + "', 
'" + password + "', '" + creator_exp + "')")
users_db_connection.commit()

answered May 6, 2012 at 1:55

user756519

Collectives™ on Stack Overflow

Why am I getting the operationalerror near 'VARCHAR' during SQL call in Python?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related