All Posts

Python Execute SQL Query

Python Execute SQL Query

Let’s learn how to execute an SQL query on an SQLite database in Python. We can use the sqlite3 module’s DB APIs to execute SQL queries on an SQLite database.

Details on how to create an SQLite cursor object are listed here.

Execute SQL Query

The sqlite3 module supports two kinds of ways to execute the SQL query in Python
programs.

  • Using the connection object execute() method
  • Using the cursor object execute() method

cursor.execute(SQL Query)

The above call executes the SQL statement. The SQL statement may be parameterized
using placeholders instead of SQL literals. The function supports two kinds of placeholders:

  • Question marks
  • Named placeholders

connection.execute(sql)

This function creates an intermediate cursor object by calling the cursor method and then calls the cursor’s execute() method.

 

Use methods like fetchone(), fetchall(), or fetchmany() to retrieve data from the database.

Example

# Python program to Execute SQL Query
# Python Tutorials – www.TestingDocs.com

import sqlite3

# Open SQLite DB Connection
connection = sqlite3.connect(“tdocs_database.db”)

cursor = connection.cursor()

# Execute SQL Query
cursor.execute(‘SELECT * FROM employees’)

rows = cursor.fetchall()
for row in rows:
print(row)

connection.commit()
connection.close()

Program Output

Run the program. The program will output the rows in the table. We can verify the table data using the DB Browser for SQLite.

Python Execute SQL Query

 

—

Python Tutorials

Python Tutorial on this website can be found at:

https://www.testingdocs.com/python-tutorials/

More information on Python is available at the official website:

  • https://www.python.org