centos6.x 安装python3 django1.8 pymysqls环境

python3安装参见:Linux 下编译安装 Python 3.4 

下面直接使用pip3(安装python3时自带安装了pip3)安装django和pymysql
[root@bogon Python-3.4.3]# pip3 install django
You are using pip version 6.0.8, however version 7.1.2 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.
Collecting django
  Downloading Django-1.8.4-py2.py3-none-any.whl (6.2MB)
    100% |################################| 6.2MB 73kB/s 
Installing collected packages: django


Successfully installed django-1.8.4
测试一下:
[root@xxx]# python3
Python 3.4.3 (default, Oct  1 2015, 17:26:54) 
[GCC 4.4.7 20120313 (Red Hat 4.4.7-16)] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import django
>>> django.get_version()
'1.8.4'

django安装了1.8.4版本

[root@bogon Python-3.4.3]# pip3 install pymysql
You are using pip version 6.0.8, however version 7.1.2 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.
Collecting pymysql
  Downloading PyMySQL-0.6.7-py2.py3-none-any.whl (69kB)
    100% |################################| 73kB 207kB/s 
Installing collected packages: pymysql


Successfully installed pymysql-0.6.7

pymysql基本操作:

（1）导入pymysql: import pymysql    #这里不报错则pymysql成功

（2）连接数据库： conn=pymysql.connect(host='localhost',user='root',passwd='root',db='test'，charset='utf8')    务必注意各等号前面的内容！charset参数可避免中文乱码

（3）获取操作游标： cur=conn.cursor()

（4）执行sql语句,插入记录：sta=cur.execute("insert 语句")  执行成功后sta值为1。更新、删除语句与此类似。

（5）执行sql语句，查询记录：cur.execute("select语句") 执行成功后cur变量中保存了查询结果记录集，然后再用循环打印结果：

for each in cur:

      print(each[1])     # each[1] 表示当前游标所在行的的第2列值