Insert any dictionary data into mysql

insert_dict_mysql.py

import MySQLdb
conn = MySQLdb.connect(host= "localhost",
                  user="root",  #give your mysql database username
                  passwd="db password", #give mysql database password
                  db="db name") #give mysql database name

x = conn.cursor()

'''
insert into mysql columns
'''
def storeData(dic):
	for key in dic.keys():

		# alter table in case the mysql column name is not found
		try:
			query = "show columns from table_name like " + "'" + key + "'"  #give mysql table_name
			val = x.execute(query)

			if (val==0):
				query_add = "ALTER TABLE table_name ADD %s VARCHAR(500)" % (key) #give mysql table_name
				x.execute(query_add)
		   		print "yes"
		except:
			conn.rollback()

	# insert into mysql columns
	for key in dic.keys():
		dic[key] = "'"+dic[key]+"'"

	column = ", ".join(dic.values())
	column_values = ', '.join(dic.keys())
	query_insert = "INSERT INTO product_details (%s) VALUES (%s) " % (column_values,column)
	print query_insert
	x.execute(query_insert)
	
	conn.commit()
	conn.close()

#give your dictionary in the below format
dic = {'Alpha':'1','Beta':'2'}
storeData(dic)