python3串連mysql

標籤：

1. 安裝PyMysql；

2.mac版如下：

 1 # -*- coding: utf-8 -*- 2 import pymysql 3 # 密碼我用*打馬賽克啦 哇哈哈 4 conn = pymysql.connect(host = ‘127.0.0.1‘, unix_socket = ‘/tmp/mysql.sock‘, user = ‘root‘ , password = ‘******‘, db = ‘mysql‘, charset = ‘utf8s‘) 5 cur = conn.cursor() 6 cur.execute("USE mysql") 7  8 cur.execute("select * from user") 9 print(cur.fetchone())10 cur.close()11 conn.close()

3. windows版如下：

注意事項：1.port後面寫int而不是str；

　　　　　2.添加charset=‘utf8‘以保證查出的中文字元能正常顯示；

 1 # -*- coding: utf-8 -*- 2 import pymysql 3  4 conn = pymysql.connect(host = ‘XXXXXX‘, port = 1234, user = ‘****‘ , password = ‘*****‘, db = ‘xxxx‘, charset = ‘utf8‘) 5 cur = conn.cursor() 6 cur.execute("USE xxxx") 7  8 cur.execute("SELECT * from  xxxx where id = 1039") 9 print(cur.fetchone())10 cur.close()11 conn.close()

 

python3串連mysql