Store data in MySQL using Python : sample code
 Store data in MYSQL in Python   Many times in your python application you may need to store results or some data into relational database and MySQL is one of the most widely used relational database.   In this post we are presenting you with a sample script to insert records in MySQL table.  In below example we will be using mysql connector python for demonstration.     import mysql.connector from mysql.connector import Error from mysql.connector import errorcode  try:     connection = mysql.connector.connect(host='localhost',                                          database='test',                                          user='root',                                          password='root')     print("connection is open")     query = """INSERT INTO Person (`Name`, `Age`, `DOB`, `Address`)                            VALUES ('ABC', 134,'2001-08-14', 'Rajasthan, India') """      cursor = co...