نوشتن در دیتابیس پایتون

import mysql.connector

print ("wants to connect")

cnx= mysql.connector.connect(user='newuser',password='user_password',
                             host='127.0.0.1',
                             database='shotor')

print('connected successfully') 
cursor=cnx.cursor()
cursor.execute('INSERT INTO friends VALUES (\'havij\',9234233,\'y\')')
cursor.execute('INSERT INTO friends VALUES (\'khers\',\'216673\',\'n\')')
name='Feeeel'
number=212622
stats='y'
cursor.execute('INSERT INTO friends VALUES (\'%s\',\'%d\',\'%c\')'%(name,number,stats))


cnx.commit()
cnx.close()