Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- "Not all parameters where used in the SQL statement".
- import mysql.connector
- con=mysql.connector.connect(user="root",password="",host="127.0.0.1",database="bdpython")
- cursor=con.cursor()
- #DATOS
- id=1
- nombre="juan"
- cursor.execute("INSERT INTO ejemplo (id,datos) VALUES(?,?)",(id,nombre,))
- con.commit()
- con.close()
- cursor.execute("INSERT INTO ejemplo (id) VALUES(?)",(id,))
- cursor.execute("INSERT INTO ejemplo (datos) VALUES(?)",(nombre,))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement