python mysql.connector和mysqlldb的区别

发布网友发布时间：2022-05-01 18:22

共2个回答

懂视网时间：2022-05-01 22:43

mysql.connector cnx = mysql.connector.connect(user=‘scott‘, password=‘tiger‘,host=‘127.0.0.1‘,database=‘employees‘) cnx.close()

import MySQLdb

db = MySQLdb.connect(host="localhost", # your host, usually localhost
   user="john", # your username
   passwd="megajonhy", # your password
   db="jonhydb") # name of the data base

cur = db.cursor() 
cur.execute("SELECT * FROM YOUR_TABLE_NAME")

MySQLdb is a C module that links against the MySQL protocol implementation in the libmysqlclient library. It is faster, but requires the library in order to work.

mysql-connector is a Python module that reimplements the MySQL protocol in Python. It is slower, but does not require the C library and so is more portable.

注：以上内容转自“http://stackoverflow.com/questions/32575857/the-differences-between-mysqldb-and-mysqlconnector”

python3-连接MySQL（mysql.connector与MySQLdb区别）

标签：tor cto blog div cal word UI sql c module

热心网友时间：2022-05-01 19:51

前者是MySQL，也就是Oracle公司官方近两年才开始提供的连接器；
后者是SUN公司存在的年代的一个开源项目，存在多年。
两者功能接近，但 mysql-python 项目已几近不维护。