Pymysql的连接
import pymysql
from pprint import pprint
'''
#SYN请求同步
#ACK确认
C---->SYN---->S
C<----ACK+SYN<----S
C----->ACK----->S
'''
'''
C---->FIN---->S
C<----ACK<----S
#服务区断在传送数据
C<----FIN<----S
C----->ACK--->S
'''
conn = pymysql.Connect(host='10.11.52.96',
port=3306,
user='hal',
passwd='123456',
db='demo',
charset='utf8')
cursor = conn.cursor(cursor=pymysql.cursors.DictCursor)
sql = "select * from stuinfo join score using(sid)"
cursor.execute(sql)
pprint(cursor.fetchall())
cursor.close()
conn.close()
插入数据
import pymysql
from pprint import pprint
conn = pymysql.connect(host='10.11.52.96', user='hal', passwd="123456",
db='demo', port=3306)
cursor=conn.cursor(cursor=pymysql.cursors.DictCursor)
sql = "insert into stuinfo(`sname`,`sex`,`age`,`city`,`seat`)value(%s,%s,%s,%s,%s)"
cursor.execute(sql,('qaz123','男',18,'上海',100))
conn.commit()
sid = cursor.lastrowid
sql = "select * from stuinfo where sid="+str(sid)
cursor.execute(sql)
pprint(cursor.fetchall())
cursor.close()
conn.close()
执行存储过程
import pymysql
from pprint import pprint
conn = pymysql.connect(host='10.11.52.96', user='hal', passwd="123456",
db='demo', port=3306)
cursor=conn.cursor(cursor=pymysql.cursors.DictCursor)
cursor.callproc('pro_demo',(21,))
pprint(cursor.fetchall())
cursor.close()
conn.close()