Python Program to delete all rows from a table using MySQL

---

In this program, you will learn how to delete all rows from a table using Python and MySQL.

---

create database xiith;

use xiith;

create table emp(id varchar(10), name varchar(30),salary int(10))

select * from emp;

Example: How to delete all rows from a table using Python and MySQL

import mysql.connector

myconn = mysql.connector.connect(host="localhost", user="root", passwd="12345678", database="xiith")
cur = myconn.cursor()

try:
    cur.execute("delete from emp")
    print("Success")

    myconn.commit()
except:
    myconn.rollback()
myconn.close()

Output:

Success