>>> import sqlite3
>>> conn = sqlite3.connect('mydb.db')
>>> cursor = conn.cursor()
>>> cursor.execute("INSERT INTO employee (emp_name, emp_dept) VALUES (?, ?)", ('Sam', 'Finance'))
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
sqlite3.OperationalError: no such table: employee
You may get the "OperationalError - no such table" error, when working with a SQL table with SQLite database in Python for the below reasons.
- Make sure that the table you are trying to access does exist.
- Make sure that you are not creating a new database (if the DB location is incorrect) thus the table does not exist.
Fix for OperationalError - no such table
- Create the table in your SQLite database before you can perform operations on it.
- If the database and the table already exist, make sure you are within the relative path where the database is.
![sqlite3.OperationalError- no such table sqlite3.OperationalError- no such table](https://code2care.org/python/fix-sqlite3-operational-error-no-such-table/images/sqlite3.OperationalError- no such table.jpg)
We can know more about the OperationalError by taking a look at "PEP-249 β Python Database API Specification v2.0"
OperationalError error is a sub-class of DatabaseError Exception which is raised when there are errors that are related to the databaseβs operation. These exceptions are not necessarily under the control of the programmer, e.g. an unexpected disconnect occurs, the data source name is not found, a transaction could not be processed, a memory allocation error occurred during processing, etc.
Facing issues? Have Questions? Post them here! I am happy to answer!
Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.
Follow him on: X
You can also reach out to him via e-mail: rakesh@code2care.org
- How to convert int to ASCII in Python
- How to make use of SQLite Module in Python?
- Split a String into Sub-string and Parse in Python
- Python: Pandas Rename Columns with List Example
- How to run Python file from Mac Terminal
- How to Exit a Loop in Python Code
- Python: How to Plot a Histogram using Matplotlib and data as list
- MD5 Hashing in Python
- Jupyter: Safari Cant Connect to the Server localhost:8888/tree
- Fix: AttributeError: str object has no attribute decode. Did you mean: encode?[Python]
- How to Read a binary File with Python
- How to add two float numbers in Python
- Python: How to install YAML Package
- Python: How to Save Image from URL
- What is Markdown in Jupyter Notebook with Examples
- How to change the Python Default version
- 33: Python Program to send an email vid GMail
- How to comment code in Python
- How to Fix AttributeError in Python
- Fix: error: Jupyter command `jupyter-nbconvert` not found [VSCode]
- How to comment out a block of code in Python
- List of All 35 Reserved Keywords in Python Programming Language 3.11
- Import Other Python Files Examples
- Python: How to add Progress Bar in Console with Examples
- 3 Ways to convert bytes to String in Python
- Create Custom Toast Android Programming - Android
- How to Add Notepad Shortcut to Desktop on Windows 11 - Windows-11
- vi undo redo command [Examples] - Mac-OS-X
- Fix: error: Jupyter command `jupyter-nbconvert` not found [VSCode] - Python
- Bash command to Read, Output and Manipulate JSON File - Bash
- PowerShell Fix: Get-Help cannot find the Help files for this cmdlet on this computer - Powershell
- The declared package does not match the expected package Eclipse - Android
- How to view Log file content using Mac Terminal - MacOS