Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import mysql.connector
- mydb = mysql.connector.connect(
- host="localhost",
- user="yourusername",
- passwd="yourpassword",
- database="mydatabase"
- )
- mycursor = mydb.cursor()
- sql = "INSERT INTO customers (name, address) VALUES (%s, %s)"
- val = ("John", "Highway 21")
- mycursor.execute(sql, val)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement