How to Execute a SQLite Statement in Python?
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.