Skip to content
Related Articles

Related Articles

Improve Article
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()

Output:

 Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.  

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning – Basic Level Course




My Personal Notes arrow_drop_up
Recommended Articles
Page :