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

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