mysql-insert.py

import mysql.connector
db = mysql.connector.connect(host="localhost",
                             user="root",
                             password="", database="db11230070")

while(True):
    npm = input("NPM Mahasiswa  :")
    nama = input("Nama Mahasiswa    :").title()
    jk = input("Jenis Kelamin (P/L) :").upper()
    prodi = input("Program Studi (SI/IF)    :").upper()
    val = (npm, nama, jk, prodi)
    cursor = db.cursor()
    sql = "INSERT INTO tblmahasiswa values (null, %s, %s, %s, %s)"
    cursor.execute(sql,val)
    db.commit()
    print("{} record berhasil disimpan". format(cursor.rowcount))

    ulang=input("Ulangi input data? (y/t)").lower()
    if(ulang!="y"):
        break