python 操作mysql

转载于 2017-10-11 11:03:00 发布 · 43 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/dennnnnis/p/7649541.html

文章标签：

#数据库 #python

本文介绍了如何利用Python的pymysql模块连接并操作MySQL数据库，包括创建连接、执行SQL语句、插入多条记录等操作。

# 通过 pymysql 连接mysql
# pip3 install pymysql
import pymysql
# 创建连接
conn = pymysql.connect(host="192.168.4.4",port=3306,user="root",passwd="12345",db="student")

# 创建游标
cursor = conn.cursor()

# 执行sql，并返回受影响行数
effect_row = cursor.execute("select * from student")

# 一条一条取
# print(cursor.fetchone())
print(cursor.fetchall())

data = [
    ("N1","2017-10-11","M"),
    ("N2","2017-10-11","F"),
    ("N3","2017-10-11","F")
]
cursor.executemany("insert INTO student (name,register_data,gender) VALUES(%s,%s,%s)",data)
conn.commit()

cursor.close()
conn.close()