import
sqlite3
connection
=
sqlite3.connect(
"company.db"
)
cursor
=
connection.cursor()
sql
=
cursor.execute(sql)
sql
=
cursor.execute(sql)
List
=
[(
1008
,
'Rkb'
,
'Boss'
,
'M'
,
"27-NOV-1864"
),
(
1098
,
'Sak'
,
'Rose'
,
'F'
,
"27-DEC-1864"
),
(
1908
,
'Royal'
,
'Bassen'
,
"F"
,
"17-NOV-1894"
)]
connection. executemany(
"INSERT INTO employee VALUES (?, ?, ?, ?, ?)"
,
List
)
print
(
"Method-1\n"
)
for
row
in
connection.execute(
'SELECT * FROM employee ORDER BY ID'
):
print
(row)
print
(
"\nMethod-2\n"
)
sql
=
cursor.execute(sql)
result
=
cursor.fetchall()
for
x
in
result:
print
(x)
connection.commit()
connection.close()