python操作mysql时mysqldb和pymysql的安装和使用

比眉伴天荒 2022-08-04 12:39 157阅读 0赞

http://[blog.csdn.net/pipisorry/article/details/48024795][blog.csdn.net_pipisorry_article_details_48024795]

# python-mysql的安装    #

## 首先安装和启动mysql ##

linux和windows下安装请参考\[[Mysql数据库安装和配置][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][https_pypi.python.org_pypi_MySQL-python]\]

不过看上面的官网，py2也可以用pip安装：

pip install MySQL-python

如果出错参考\[[mysql-python安装时EnvironmentError: mysql\_config not found][mysql-python_EnvironmentError_ mysql_config not found]\]

\[[Ubuntu安装MySql for Python的出错及解决][Ubuntu_MySql for Python]\]

### windows下安装 ###

python2和python3安装都可以使用whl文件安装\[[mysqldb for python3][]\]

## 启动mysql并建立数据库 ##

Linux下启动mysql服务器

sudo service mysql status

其它参考

\[[Mysql数据库安装和配置][Mysql]\]

建立数据库

CREATE DATABASE 库名;

其它建表操作可以直接在python代码中实现。

\[[mysql语法、特殊符号及正则表达式的使用][mysql]\]

[皮皮blog][blog]

# 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())

[皮皮blog][blog]

## 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][blog.csdn.net_pipisorry_article_details_48024795]

[blog.csdn.net_pipisorry_article_details_48024795]: http://blog.csdn.net/pipisorry/article/details/48024795
[Mysql]: https://blog.csdn.net/pipisorry/article/details/46773507
[https_pypi.python.org_pypi_MySQL-python]: https://pypi.python.org/pypi/MySQL-python
[mysql-python_EnvironmentError_ mysql_config not found]: http://www.cnblogs.com/xiazh/archive/2012/12/12/2814289.html
[Ubuntu_MySql for Python]: https://blog.csdn.net/zlp1992/article/details/44521135
[mysqldb for python3]: http://www.lfd.uci.edu/~gohlke/pythonlibs/6icuform/mysqlclient-1.3.6-cp34-none-win_amd64.whl
[mysql]: https://blog.csdn.net/pipisorry/article/details/46773545
[blog]: http://blog.csdn.net/pipisorry