import mysql.connector
connection = mysql.connector.connect(host="localhost",user="root",password="root")     #connection object to connect python with mysql
print(connection)							
if connection.is_connected():                                        #print connection object memory address
        print("Python mysql connected")                       #check connection is established or not
    	cursor = connection.cursor()                  #create cursor to activate pointer to execute commands
    	cursor.execute("CREATE DATABASE PYMYSQL;") #run execute() function to execute queries
    	cursor.execute("USE PYMYSQL;")          
    	cursor.execute("""CREATE TABLE STUDENTS
(
S_NAME CHAR(50),
AGE INT
);""")
    	cursor.execute("INSERT INTO STUDENTS VALUES('KARAN',17);")
    	cursor.execute("""INSERT INTO STUDENTS VALUES
("MAHMOOD",16),
("NITHIN",17);""")
    	connection.commit()          #commit function accept database and table creation and insert records into it.
    	connection.close()						     #To close the connection
else:
    	print("Python mysql not connected")
 

aW1wb3J0IG15c3FsLmNvbm5lY3Rvcgpjb25uZWN0aW9uID0gbXlzcWwuY29ubmVjdG9yLmNvbm5lY3QoaG9zdD0ibG9jYWxob3N0Iix1c2VyPSJyb290IixwYXNzd29yZD0icm9vdCIpICAgICAjY29ubmVjdGlvbiBvYmplY3QgdG8gY29ubmVjdCBweXRob24gd2l0aCBteXNxbApwcmludChjb25uZWN0aW9uKQkJCQkJCQkKaWYgY29ubmVjdGlvbi5pc19jb25uZWN0ZWQoKTogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgI3ByaW50IGNvbm5lY3Rpb24gb2JqZWN0IG1lbW9yeSBhZGRyZXNzCiAgICAgICAgcHJpbnQoIlB5dGhvbiBteXNxbCBjb25uZWN0ZWQiKSAgICAgICAgICAgICAgICAgICAgICAgI2NoZWNrIGNvbm5lY3Rpb24gaXMgZXN0YWJsaXNoZWQgb3Igbm90CiAgICAJY3Vyc29yID0gY29ubmVjdGlvbi5jdXJzb3IoKSAgICAgICAgICAgICAgICAgICNjcmVhdGUgY3Vyc29yIHRvIGFjdGl2YXRlIHBvaW50ZXIgdG8gZXhlY3V0ZSBjb21tYW5kcwogICAgCWN1cnNvci5leGVjdXRlKCJDUkVBVEUgREFUQUJBU0UgUFlNWVNRTDsiKSAjcnVuIGV4ZWN1dGUoKSBmdW5jdGlvbiB0byBleGVjdXRlIHF1ZXJpZXMKICAgIAljdXJzb3IuZXhlY3V0ZSgiVVNFIFBZTVlTUUw7IikgICAgICAgICAgCiAgICAJY3Vyc29yLmV4ZWN1dGUoIiIiQ1JFQVRFIFRBQkxFIFNUVURFTlRTCigKU19OQU1FIENIQVIoNTApLApBR0UgSU5UCik7IiIiKQogICAgCWN1cnNvci5leGVjdXRlKCJJTlNFUlQgSU5UTyBTVFVERU5UUyBWQUxVRVMoJ0tBUkFOJywxNyk7IikKICAgIAljdXJzb3IuZXhlY3V0ZSgiIiJJTlNFUlQgSU5UTyBTVFVERU5UUyBWQUxVRVMKKCJNQUhNT09EIiwxNiksCigiTklUSElOIiwxNyk7IiIiKQogICAgCWNvbm5lY3Rpb24uY29tbWl0KCkgICAgICAgICAgI2NvbW1pdCBmdW5jdGlvbiBhY2NlcHQgZGF0YWJhc2UgYW5kIHRhYmxlIGNyZWF0aW9uIGFuZCBpbnNlcnQgcmVjb3JkcyBpbnRvIGl0LgogICAgCWNvbm5lY3Rpb24uY2xvc2UoKQkJCQkJCSAgICAgI1RvIGNsb3NlIHRoZSBjb25uZWN0aW9uCmVsc2U6CiAgICAJcHJpbnQoIlB5dGhvbiBteXNxbCBub3QgY29ubmVjdGVkIikK