Read from (SELECT) Database table – SQLite3 with Python 3

Source Code

import sqlite3
db = sqlite3.connect('ganesha.db')
cursor = db.cursor()
id1 = 2
cursor.execute('select *from info3 where id=?',(id1,))

multiplerecord = cursor.fetchall()
# print(singlerecord[1])
for row in multiplerecord:
   # print(row)
     print('{0}:{1}'.format(row[0],row[1]))