数据库

数据库

[python3教程][10]

• 连接MySQL：

      db = pymysql.connect(host='localhost', port=3306,user='root',passwd='2005726',db='review')
      cur = db.cursor()
      self.db = db
      self.cur = cur
      self.fetch_data()
  

• 读取数据：

      train = []
      self.cur.execute("SELECT * FROM Bug_Report_Data")
      for row in self.cur:
          review = str(row[16])
          review= str(review.decode('utf-8', errors='ignore'))
          train.append((review, 'bug'))
  

使用pymysql连接Mysql

import pymysql;
def access_mysql():
     conn = pymysql.connect(host='localhost', port=3306,user='root',db='test')
    cur = conn.cursor()
    cur.execute("SELECT * FROM dictionarylimit 10")
    for r in cur:
        print("row_number:"+str(cur.rownumber))
        print("id:"+str(r[0])+"key:"+str(r[1])+" mean:"+str(r[2]))
    cur.close()
    conn.close()

if __name__== '__main__':
    access_mysql();

评论

作者: Rowl1ng