http://blog.csdn.net/pipisorry/article/details/48024795
python-mysql的安装
首先安装和启动mysql
linux和windows下安装请参考[Mysql数据库安装和配置]
安装python和mysql的连接
linux下安装
python3安装相当简单:
$ pip install PyMySQL
python2安装很麻烦:
$ gunzip MySQL-python-1.2.2.tar.gz
$ tar -xvf MySQL-python-1.2.2.tar
$ cd MySQL-python-1.2.2
$ python setup.py build
$ python setup.py install
[https://pypi.python.org/pypi/MySQL-python]
不过看上面的官网,py2也可以用pip安装:
pip install MySQL-python
如果出错参考[mysql-python安装时EnvironmentError: mysql_config not found]
[Ubuntu安装MySql for Python的出错及解决]
windows下安装
python2和python3安装都可以使用whl文件安装[mysqldb for python3]
启动mysql并建立数据库
Linux下启动mysql服务器
sudo service mysql status
其它参考
建立数据库
CREATE DATABASE 库名;
其它建表操作可以直接在python代码中实现。
python操作mysql数据库
示例
try: import MySQLdb # py2 except: import pymysql # py3 import traceback py_version = 3 class MySQLOpt(): def __init__(self): self.connectDB() def __del__(self): self.closeDB() def connectDB(self): # 打开数据库连接 try: if py_version == 2: self.db = MySQLdb.connect("localhost", "root", "****", "databasename", charset='utf8') else: self.db = pymysql.connect("localhost", "root", "****", "databasename", charset='utf8') except: print('no such database') # print(traceback.format_exc()) def closeDB(self): # 关闭数据库连接 self.db.close() def createTable(self, table_name, table_field, drop=False): ''' 创建表 :param table_name: :param table_field: :param drop: :return: ''' # 使用cursor()方法获取操作游标 cursor = self.db.cursor() # 如果数据表已经存在使用 execute() 方法删除表。 if drop: cursor.execute("drop table if exists " + table_name) sql = "CREATE TABLE " + table_name + " (" + table_field + ")" try: cursor.execute(sql) except: print(traceback.format_exc())
python调用sqlite3数据库命令
conn = sqlite3.connect(".\database_name") for row in conn.execute("SELECT name, value FROM table_name"):...
from:http://blog.csdn.net/pipisorry/article/details/48024795