How to Execute a SQLite Statement in Python?

Last Updated : 16 May, 2021

In this article, we are going to see how to execute SQLite statements using Python. We are going to execute how to create a table in a database, insert records and display data present in the table.

In order to execute an SQLite script in python, we will use the execute() method with connect() object:

connection_object.execute(“sql statement”)

Approach:

To perform the execution, we have to follow the below steps:

Import sqlite3 module. This statement will import SQLite module, import keyword is used to import a module in python.

import sqlite3

Create a connection to the database. This will create a new database by connecting the database, here we have to specify the database name and connect to it using a cursor object.

connection_object = sqlite3.connect('database_name.db')

Execute query connection object. Here we need to execute the connection object by specifying the SQL statement.

connection_object.execute("sql statement");

Finally terminate the connection using the close() method.

connection_object.close();

Example 1: Python code to create a database and a table, below are the steps:

Importing sqlite3 module
Create a connection by using an object to connect with the college_details database
SQLite execute a query to create a table

Python3

# importing sqlite3 module 
import sqlite3 
  
# create connection by using object to  
# connect with college_details database 
connection = sqlite3.connect('college.db') 
  
  
# sqlite execute query to create a table 
connection.execute("""create table college( 
        geek_id, 
        geek_name, 
        address 
    );""") 
  
print("Table created successfully") 
  
# terminate the connection 
connection.close() 

Output:

Database created:

Example 2: Python code to insert and display data into the above-created table.

Python3

# importing sqlite3 module 
import sqlite3 
  
# create connection by using object  
# to connect with college_details  
# database 
connection = sqlite3.connect('college.db') 
  
# sqlite execute query to insert a table 
connection.execute( 
    '''insert into college values ( '7058', 'sravan kumar','hyd' )''') 
connection.execute( 
    '''insert into college values ( '7059', 'jyothika','tenali' )''') 
connection.execute( 
    '''insert into college values ( '7072', 'harsha verdhan','nandyal' )''') 
connection.execute( 
    '''insert into college values ( '7099', 'virinchi','Guntur' )''') 
  
# sqlite execute query to display data 
# in the college 
a = connection.execute("select * from college") 
  
# fetch all records 
print(a.fetchall()) 
  
# terminate the connection 
connection.close() 