python3 连接mysql数据库

import pymysqlconn = pymysql.connect(host='10.2.3.5', port=3306, user='root', passwd='',db='mydata',charset='utf8')cur = conn.cursor()cur.execute("SELECT * FROM bankbase")for r in cur.fetchall(): ...

C站训练营学

248人浏览 · 2019-06-27 10:40:28

C站训练营学 · 2019-06-27 10:40:28 发布

   import pymysql
  
   conn = pymysql.connect(host='10.2.3.5', port=3306, user='root', passwd='',db='mydata',charset='utf8')
  
   cur = conn.cursor()
  
   cur.execute("SELECT * FROM bankbase")
  
   for r in cur.fetchall():
  
   print(r)
  
   cur.close()
  
   conn.close()