UPDATE and DELETE – SQLite3 with Python 3 | Lecture 18

Source Code

import sqlite3
db = sqlite3.connect('ganesha.db')
cursor = db.cursor()
id1=2
name1 = 'AAA'
# cursor.execute('update info3 set name = ? where id = ?',(name1,id1))
cursor.execute('delete from info3 where id = ?',(id1,))
db.commit()