Skip to content
Related Articles

Related Articles

How to Execute a SQLite Statement in Python?

View Discussion
Improve Article
Save Article
  • Last Updated : 16 May, 2021
View Discussion
Improve Article
Save Article

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:


My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!