Getting Error in insert record in MySql from Python

Question

import mysql.connector
from mysql.connector import Error

def query_with_fetchone(tit):    

    try:
        conn = mysql.connector.connect(host='localhost',
                                   database='python_mysql',
                                   user='root',
                                   password='')     

        cursor = conn.cursor()
        query = "INSERT INTO sample(title) VALUES(%s)"
        args = (tit)
        cursor.execute(query,args)

        if cursor.lastrowid:
            print('last insert id', cursor.lastrowid)
        else:
            print('last insert id not found')

        conn.commit()
    except Error as e:
        print(e)

    finally:
        cursor.close()
        conn.close()

if __name__ == '__main__':
    query_with_fetchone('Vrajesh')

I am getting following error:

1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%s)' at line 1

Please Guide I am new Python

I have two guesses that may be helpful: (1) you should put an ending semicolon at the end of the query, and (2) try to change args into a list, not a tuple. — Alessandro
– Alessandro, Commented Dec 2, 2017 at 10:44

Nestor Yanchuk · Accepted Answer · 2017-12-02 10:47:09Z

1

Your args is not a tuple, tuple with one element requires comma.

args = (tit,)

It may be the solution

answered Dec 2, 2017 at 10:47

Nestor Yanchuk

1,2869 silver badges10 bronze badges

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

1 Comment

Vrajesh Doshi Over a year ago

Thank You. It was the expected solution

Collectives™ on Stack Overflow

Getting Error in insert record in MySql from Python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related