import sqlite3 # Connection with the DataBase # 'library.db' connection = sqlite3.connect('library.db') cursor = connection.cursor() # SQL piece of code Executed # SQL piece of code Executed cursor.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 database connection.commit() # Connection closed(broken)  # with DataBase connection.close() 

import sqlite3 # Connection with the DataBase # 'library.db' connection = sqlite3.connect('library.db') cursor = connection.cursor() # SQL piece of code Executed cursor.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() for x in result: print(x) # Changes saved into database connection.commit() # Connection closed(broken)  # with DataBase connection.close() 

import sqlite3 # Connection with the DataBase # 'library.db' connection = sqlite3.connect('library.db') cursor = connection.cursor() # SQL piece of code Executed cursor.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() for x in result: print(x) # Changes saved into database connection.commit() # Connection closed(broken) # with DataBase connection.close() 

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