python使用mysql数据库.docxVIP

一，安装mysql?如果是windows?用户，mysql?的安装非常简单，直接下载安装文件，双击安装文件一步一步进行操作即可。Linux?下的安装可能会更加简单，除了下载安装包进行安装外，一般的linux?仓库中都会有mysql?，我们只需要通过一个命令就可以下载安装：Ubuntu\deepinsudo?apt-get?install?mysql-server?Sudo?apt-get?install??mysql-clientcentOS/redhatyum?install?mysql?二，安装MySQL-python要想使python可以操作mysql?就需要MySQL-python驱动，它是python?操作mysql必不可少的模块。下载地址：/pypi/MySQL-python/下载MySQL-python-1.2.5.zip?文件之后直接解压。进入MySQL-python-1.2.5目录:python?setup.py?install?三，测试测试非常简单，检查MySQLdb?模块是否可以正常导入。?fnngj@fnngj-H24X:~/pyse$ python Python 2.7.4 (default, Sep 26 2013, 03:20:56) [GCC 4.7.3] on linux2Type help, copyright, credits or license for more information. import MySQLdb?没有报错提示MySQLdb模块找不到，说明安装OK?，下面开始使用python?操作数据库之前，我们有必要来回顾一下mysql的基本操作：??四，mysql?的基本操作?$?mysql?-u?root?-p??（有密码时）$?mysql?-u?root（无密码时）?mysql show databases; // 查看当前所有的数据库+--------------------+| Database |+--------------------+| information_schema || csvt || csvt04 || mysql || performance_schema || test |+--------------------+6 rows in set (0.18 sec)mysql use test; //作用与test数据库Database changedmysql show tables; //查看test库下面的表Empty set (0.00 sec)//创建user表，name 和password 两个字段mysql CREATE TABLE user (name VARCHAR(20),password VARCHAR(20)); Query OK, 0 rows affected (0.27 sec)//向user表内插入若干条数据mysql insert into user values(Tom,1321);Query OK, 1 row affected (0.05 sec)mysql insert into user values(Alen,7875);Query OK, 1 row affected (0.08 sec)mysql insert into user values(Jack,7455);Query OK, 1 row affected (0.04 sec)//查看user表的数据mysql select * from user;+------+----------+| name | password |+------+----------+| Tom | 1321 || Alen | 7875 || Jack | 7455 |+------+----------+3 rows in set (0.01 sec)//删除name 等于Jack的数据mysql delete from user where name = Jack;Query OK, 1 rows affected (0.06 sec)//修改name等于Alen 的password 为 1111mysql update user set password=1111 where name = Alen;Query OK, 1 row affected (0.05 sec)Rows matched: 1 Changed: 1 Warnings: 0//查看表内容mysql select * from