Question

python pymysql 怎么插入数据

Answer 1

import MySQLdb
conn=MySQLdb.connect(host='localhost',
                                     user='db_user',
                                     passwd='db_passwd',
                                     db='db_name',
                                     port=3306)
cur=conn.cursor()
cur.execute('INSERT INTO `uid`(`id`,`key`) VALUES (%s,%s)'
                        ,(1234,"45678")
                        )
conn.commit()
conn.close()