Python connect MySQL pymysql module

The following demo is based on the MySQLdb module in Python2

First, insert data

?

123456789101112131415

import MySQLdb conn = MySQLdb.connect(host=‘127.0.0.1‘,user=‘root‘,passwd=‘1234‘,db=‘mydb‘) cur = conn.cursor() reCount = cur.execute(‘insert into UserInfo(Name,Address) values(%s,%s)‘,(‘alex‘,‘usa‘))# reCount = cur.execute(‘insert into UserInfo(Name,Address) values(%(id)s, %(name)s)‘,{‘id‘:12345,‘name‘:‘wupeiqi‘}) conn.commit() cur.close()conn.close() print reCount

ImportMysqldbconn= MySQLdb.connect (host='127.0.0.1', user='Root', passwd='1234', db='MyDB') cur=conn.cursor () Li=[     ('Alex','USA'),     ('SB','USA'),]recount= Cur.executemany ('INSERT INTO UserInfo (name,address) VALUES (%s,%s)', Li) conn.commit () Cur.close () conn.close ()Printrecount BULK INSERT data

BULK INSERT Data

Ii. deletion of data

?

1234567891011121314

import MySQLdbconn = MySQLdb.connect(host=‘127.0.0.1‘,user=‘root‘,passwd=‘1234‘,db=‘mydb‘)cur = conn.cursor()reCount = cur.execute(‘delete from UserInfo‘)conn.commit()cur.close()conn.close()print reCount

Third, modify the data

?

12345678910111213

import MySQLdbconn = MySQLdb.connect(host=‘127.0.0.1‘,user=‘root‘,passwd=‘1234‘,db=‘mydb‘) cur = conn.cursor()reCount = cur.execute(‘update UserInfo set Name = %s‘,(‘alin‘,))conn.commit()cur.close()conn.close()print reCount

Iv. Data Search

?

1234567891011121314151617181920212223242526272829303132333435363738394041424344

# ############################## fetchone/fetchmany(num)  ##############################import MySQLdbconn = MySQLdb.connect(host=‘127.0.0.1‘,user=‘root‘,passwd=‘1234‘,db=‘mydb‘)cur = conn.cursor()reCount = cur.execute(‘select * from UserInfo‘)print cur.fetchone()print cur.fetchone()cur.scroll(-1,mode=‘relative‘)print cur.fetchone()print cur.fetchone()cur.scroll(0,mode=‘absolute‘)print cur.fetchone()print cur.fetchone()cur.close()conn.close()print reCount# ############################## fetchall  ##############################import MySQLdbconn = MySQLdb.connect(host=‘127.0.0.1‘,user=‘root‘,passwd=‘1234‘,db=‘mydb‘)#cur = conn.cursor(cursorclass = MySQLdb.cursors.DictCursor)cur = conn.cursor()reCount = cur.execute(‘select Name,Address from UserInfo‘)nRet = cur.fetchall()cur.close()conn.close()print reCountprint nRetfor i in nRet:    print i[0],i[1]

　　　　

　　

Python connect MySQL pymysql module