Delete a Record Using Python and MySQL

Here is a code that will show and teach you how to delete a single record in Python and MySQL.

I am currently accepting programming work, it projects, school and application development.

programming projects, thesis and capstone projects, IT consulting.

work, computer tutorials, and web development work kindly contact me in the following email address for further details.  If you want to advertise on my website kindly contact me also in my email address also. Thank you.

My email address is the following jakerpomperada@gmail.com, jakerpomperada@aol.com, and jakerpomperada@yahoo.com.

My mobile number here in the Philippines is 09173084360.

My telephone number at home here in Bacolod City, Negros Occidental Philippines is  +63 (034) 4335675.

Here in Bacolod I also accepting computer repair, networking and Arduino Project development at a very affordable price.

My personal website is http://www.jakerpomperada.com

Program Listing

import pymysql

connection = pymysql.connect(

    host='localhost',

    user='root',

    password='',

    db='my_python',

)

print("")

print("DELETE RECORD")

print("")

id = input("Enter users ID Number :  ")

print("")

try:

    with connection.cursor() as cursor:

        sql = "DELETE FROM users WHERE id = %s"

        try:

            cursor.execute(sql,(id))

            print("Record Successfully deleted in the database")

        except:

            print("Record not found")

    connection.commit()

finally:

    connection.close()