Python3 操作数据库

1 安装插件

安装MySQL-python出错：

Collecting MySQL-python
  Using cached https://files.pythonhosted.org/packages/a5/e9/51b544da85a36a68debe7a7091f068d802fc515a3a202652828c73453cad/MySQL-python-1.2.5.zip
    ERROR: Complete output from command python setup.py egg_info:
    ERROR: Traceback (most recent call last):
      File "<string>", line 1, in <module>
      File "/private/var/folders/c2/sdkt0kk15r5dbbpt28jq_5k80000gn/T/pip-install-yyt4q0h8/MySQL-python/setup.py", line 13, in <module>
        from setup_posix import get_config
      File "/private/var/folders/c2/sdkt0kk15r5dbbpt28jq_5k80000gn/T/pip-install-yyt4q0h8/MySQL-python/setup_posix.py", line 2, in <module>
        from ConfigParser import SafeConfigParser
    ModuleNotFoundError: No module named 'ConfigParser'
    ----------------------------------------
ERROR: Command "python setup.py egg_info" failed with error code 1 in /private/var/folders/c2/sdkt0kk15r5dbbpt28jq_5k80000gn/T/pip-install-yyt4q0h8/MySQL-python/

原因python不支持，安装替代

pip install mysql-connector

Collecting mysql-connector
  Downloading https://files.pythonhosted.org/packages/28/04/e40098f3730e75bbe36a338926f566ea803550a34fb50535499f4fc4787a/mysql-connector-2.2.9.tar.gz (11.9MB)
     |████████████████████████████████| 11.9MB 69kB/s 
Building wheels for collected packages: mysql-connector
  Building wheel for mysql-connector (setup.py) ... done
  Stored in directory: /Users/dotch/Library/Caches/pip/wheels/8c/83/a1/f8b6d4bb1bd6208bbde1608bbfa7557504bed9eaf2ecf8c175
Successfully built mysql-connector
Installing collected packages: mysql-connector
Successfully installed mysql-connector-2.2.9

2 示例

db = mysql.connector.connect(host='localhost', port=3306, user='root', passwd='xxx', db='xxx')
cursor = db.cursor()