pythonevemysql_python连接MySQ数据库

python 是目前比较流行的语言&＃xff0c;所以学习一下

首先需要 安装MySQL-python驱动

下载地址&＃xff1a;http://dev.mysql.com/downloads/connector/python/

根据自己操作系统和python版本选择相对应的驱动

例如(mysql-connector-python-2.1.3-py2.7-winx64.msi)

接下来演示&＃xff1a;如何连接到MySQL服务器的zizai数据库

Python 2.7.12 (v2.7.12:d33e0cf91556, Jun 27 2016, 15:24:40) [MSC v.1500 64 bit (AMD64)] on win32

Type "help", "copyright", "credits" or "license" for more information.

>>> import mysql.connector

>>> conn&＃61;mysql.connector.connect(

... user&＃61;&＃39;root&＃39;,

... password&＃61;&＃39;root&＃39;,

... database&＃61;&＃39;zizai&＃39;)

>>> cursor&＃61;conn.cursor()

>>> cursor.execute(&＃39;select * from user where 1&＃61;1&＃39;)

>>> values&＃61;cursor.fetchall()

>>> values

[(1, u&＃39;xxa&＃39;), (1, u&＃39;xxb&＃39;), (1, u&＃39;xxx&＃39;)]

>>> cursor.close()

True

>>> conn.close()

>>>