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