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:
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.
- 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.
- Finally terminate the connection using the close() method.
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
Example 2: Python code to insert and display data into the above-created table.
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