import pymysql
#1.建立连接(客户端连接服务端)
conn = pymysql.connect(
host='',
port=3306,
user='root',
password='',
database='',
charset='utf8' #不带-
)
#2.创建数据库访问的游标
cursor = conn.cursor(pymysql.cursors.DictCursor)
cursor = conn.cursor()
sql = "insert into digital_image(image_name) values('pysqltest01');"
rows = cursor.execute(sql)
print(rows)
conn.commit()
pymysql 添加数据到数据库
最新推荐文章于 2024-04-18 08:58:06 发布