pymysql insert dynamic

pymysql

Python Select dynamic Operation.

Python Select Dynamic

pymysql insert dynamic

Python insert Dynamic Operation

we need to use placeholder. With MYSqLdb, you should use a placeholder of %s to format all the data value as string. MYSQL will perform type conversion as necessery. if we wanted to give multiple value as placeholder we can use tuple.

Code :

import pymysql
 conn = pymysql.connect(
        host='localhost',
        user='root',
        password="12345",
        db='sakila',
 )
 get_id = int(input("enter the id"))
 get_name = input("enter the name")
 cur = conn.cursor()
 str1 = "INSERT INTO teacher VALUES (%s,%s)"
 cur.execute(str1, (get_id, get_name))
 conn.commit()
 conn.close()