import sqlite3
# Connect to the database
con = sqlite3.connect('database.db')
# Create a cursor object
cursor = con.cursor()
# Update user name based on ID
user_id = 2
new_name = "John Doe"
cursor.execute("UPDATE users SET name = ? WHERE id = ?", (new_name, user_id))
# Commit the changes
con.commit()
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter