Integrate sql with python by importing the mysql module to search an employee using using empno and if present in the table

Question

(question cont..) display the record , if not present display appropriate message

Answer 1

What is empno?

Answer 2

Empno is a column name in MySQL table

Answer 3

First pip install pyodbc
I reccomend you mysql odbc 8.0 Unicode Driver 32 and 64bit
Then in your python code:
import pyodbc
from tkinter import messagebox
cn=pyodbc.connect{...} = connect to your server, userid,password etc.
cursor=cn.cursor()
sql="Select empco from employee where..."
# where you can specify your conditon
Then next in code:
cursor.execute(sql)
rowDB = cursor.fetchone()
if rowDB is None:
messeagebox.showerror('Error')

Answer 4

Bhej chod