使用python操作mysql数据库

通过python连接数据库:

# import pymysql
#
# conn = pymysql.connect(host='localhost', user='root', password='******', database='python01')
# cur = conn.cursor(pymysql.cursors.DictCursor)


# ret = cur.execute('select * from book')
# for i in range(ret):
#     row1 = cur.fetchone()
#     print(row1)


# row2 = cur.fetchmany(3) # 按照指定参数取n条
# print(row2)
# row3 = cur.fetchall()   # 取所有，过于浪费内存
# print(row3)



# cur = conn.cursor()
# sql = 'insert into book values(%s,%s,%s,%s,%s)'

** 操作文件:**

# with open('file', encoding='utf-8') as f:
#     for line in f:
#         try:
#             lst = line.strip().split('|')
#             cur.execute(sql, lst)
#             conn.commit()
#         except:
#             conn.rollback()
# cur.close()
# conn.close()