importsqlite3# Connection with the DataBase# 'library.db'connection=sqlite3.connect("library.db")cursor=connection.cursor()# SQL piece of code Executed# SQL piece of code Executedcursor.executescript("""    CREATE TABLE people(        firstname,        lastname,        age    );    CREATE TABLE book(        title,        author,        published    );    INSERT INTO    book(title, author, published)    VALUES (        'Dan Clarke''s GFG Detective Agency',        'Sean Simpsons',        1987    );    """)sql="""SELECT COUNT(*) FROM book;"""cursor.execute(sql)# The output in fetched and returned# as a List by fetchall()result=cursor.fetchall()print(result)sql="""SELECT * FROM book;"""cursor.execute(sql)result=cursor.fetchall()print(result)# Changes saved into databaseconnection.commit()# Connection closed(broken)# with DataBaseconnection.close()

importsqlite3# Connection with the DataBase# 'library.db'connection=sqlite3.connect("library.db")cursor=connection.cursor()# SQL piece of code Executedcursor.execute("""    CREATE TABLE book(        title,        author,        published);""")List=[('A','B',2008),('C','D',2008),('E','F',2010)]connection.executemany("""    INSERT INTO    book(title, author, published)    VALUES (?, ?, ?)""",List)sql="""      SELECT * FROM book;"""cursor.execute(sql)result=cursor.fetchall()forxinresult:print(x)# Changes saved into databaseconnection.commit()# Connection closed(broken)# with DataBaseconnection.close()

importsqlite3# Connection with the DataBase# 'library.db'connection=sqlite3.connect("library.db")cursor=connection.cursor()# SQL piece of code Executedcursor.execute("""    CREATE TABLE book(        title,        author,        published);""")List=[('A','B',2008),('C','D',2008),('E','F',2010)]connection.executemany("""    INSERT INTO    book(title, author, published)    VALUES (?, ?, ?)""",List)sql="""SELECT * FROM book;"""cursor.execute(sql)result=cursor.fetchall()forxinresult:print(x)# Changes saved into databaseconnection.commit()# Connection closed(broken)# with DataBaseconnection.close()

importsqlite3# Connection created with the# database using sqlite3.connect()connection=sqlite3.connect("company.db")cursor=connection.cursor()# Create Table command executedsql="""        CREATE TABLE employee (        ID INTEGER PRIMARY KEY,        fname VARCHAR(20),        lname VARCHAR(30),        gender CHAR(1),        dob DATE);"""cursor.execute(sql)# Single Tuple insertedsql="""        INSERT INTO employee        VALUES (1007, "Will", "Olsen", "M", "24-SEP-1865");"""cursor.execute(sql)# Multiple Rows insertedList=[(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")# Multiple Rows fetched from# the Databaseforrowinconnection.execute('SELECT * FROM employee ORDER BY ID'):print(row)print("\nMethod-2\n")# Method-2 to fetch multiple# rowssql="""        SELECT * FROM employee ORDER BY ID;"""cursor.execute(sql)result=cursor.fetchall()forxinresult:print(x)connection.commit()connection.close()