Insert Record Using Python and MySQL

Here is a simple code that I wrote how to insert a record using Python and MySQL. The code is very simple and easy to understand.

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

insert.py

import pymysql

connection = pymysql.connect(

    host='localhost',

    user='root',

    password='',

    db='my_python',

)

print("")

print("ADD RECORD")

print("")

name1 = input("Enter users name : ")

age1 = input("Enter users age : ")

address1 = input("Enter users address :  ")

print("")

try:

    with connection.cursor() as cursor:

        sql = "INSERT INTO users(name,age,address) VALUES (%s,%s,%s)"

        try:

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

            print("Record Successfully added in the database")

        except:

            print("Oops! Something wrong")

    connection.commit()

finally:

    connection.close()