PyMySql模块增删查改基本操作

代码如下：

</pre><pre name="code" class="python">##设置编码格式为utf8避免中文乱码
#encoding:utf8
import pymysql


##查询
def select():
    conn = pymysql.connect(user='root', passwd='你的密码',
                     host='localhost', db='test',charset='utf8')
    cur = conn.cursor()
    cur.execute("SELECT * FROM user")
    for r in cur:
          print("row_number:" , (cur.rownumber) )        
          print("id:"+str(r[0])+" name:"+str(r[1])+" password:"+str(r[2])) 
    cur.close()    
    conn.close()

##插入
def insert(name,pwd):
    conn = pymysql.connect(user='root', passwd='你的密码',
                     host='localhost', db='test',charset='utf8')
    cur