Python3 pymysql Connect MySQL Database

#!/usr/bin/python#-*-Coding:utf8-*-ImportPymysql#取得数据库连接对象conn = Pymysql.connect (host=' 127.0.0.1 ', port=3306, user=' Root ', passwd=' 1234 ', db=' python ')#取得游标对象cur = conn.cursor ()#插入数据Cur.execute ("INSERT into student (name,sex,age) VALUES (' 3 ', ' 0 ', '") ") Conn.commit ()#修改数据Cur.execute ("UPDATE student SET age = ALL in WHERE id = 2") Conn.commit ()#删除数据Cur.execute ("DELETE from student WHERE name = ' 3 '") Conn.commit ()############################################ Be sure to Conn.commit when the data changes () #############################################查询数据Cur.execute (' SELECT *from student ') forRinchCur.fetchall ():Print(r) Cur.close () Conn.close ()

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Python3 pymysql connection to MySQL database