Update a Record Using Python and MySQL

A simple program that will show you how to update a record using Python and MySQL. I have a great time learning Python it is easy to so many  information that I can learn and get over the Internet.

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("UPDATE RECORD")

print("")

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

name1 = input("Enter users name : ")

age1 = input("Enter users age : ")

address1 = input("Enter users address :  ")

print("")

try:

    with connection.cursor() as cursor:

        sql = "UPDATE users SET name=%s, age=%s,address=%s WHERE id = %s"

        try:

            cursor.execute(sql,(name1.upper(),age1,address1.upper(),id1))

            print("Record Successfully updated in the database")

        except:

            print("Oops! Something wrong")

    connection.commit()

finally:

    connection.close()