cnx = mysql.connector.connect(user='behafarin', password='127281', host='localhost'

, database='shabesh', charset='utf8', auth_plugin='mysql_native_password')

cursor = cnx.cursor()

query = 'insert into Tehran (location, area, room, price) values(%s, %s, %s, %s)'

val = (location.encode('utf-8'), area, room, price)

# print(type(location), type(area), type(room), type(price))

# print(query)

# print(val)

cursor.execute(query, val)

cnx.commit()