连接数据库并插入数据
问题:自增字段怎么插入? 答: 设置自增字段为null,然后插入时要加上增字段
import pymysql
import time
db = pymysql.connect(host='localhost', user='root', password='root', charset='utf8')
cursor = db.cursor()
cursor.execute('use demo')
num= int(time.time())
print(num)
id = 'null'
insert_sql = f"INSERT INTO userinfo VALUES({id},'李四1', {num}, 2), ({id},'李四333', {num}, 23)"
cursor.execute(insert_sql)
db.commit()
sql_query = "SELECT * FROM userinfo"
cursor.execute(sql_query)
result = cursor.fetchall()
print(result)
cursor.close()
db.close()
问题: 如何插入多条数据? 答: executemany
insert_many_sql = "INSERT INTO userinfo(user_name,num,sex) VALUES(%s,%s,%s)"
data_to_insert = [('往往', num, 2), ('七七', num, 22), ('森森', num, 23)]
cursor.executemany(insert_many_sql, data_to_insert)