1、检查用户环境:已经安装mysql-server,已经安装python-mysqldb 组件
aptitude show mysql-server; aptitude show python-mysqldb
2、创建数据库,创建表,添加数据,修改mysql数据库的密码为Oracle11g
use mysql;
update user set password=password('Oracle11g') where user='root';
flush privileges;
---------------------
create database myfamily;
use myfamily;
create table people(id int, name varchar(30), age int, sex char(1));
insert into people values(0,'Zihao Xu',5,'M');
select * from people;exit;
update user set password=password('Oracle11g') where user='root';
flush privileges;
---------------------
create database myfamily;
use myfamily;
create table people(id int, name varchar(30), age int, sex char(1));
insert into people values(0,'Zihao Xu',5,'M');
select * from people;exit;
phoenix@debian:~$ cat pyMysql.py
#!/usr/bin/python
#filename:pyMysql.py
#coding:utf-8
import MySQLdb
conn = MySQLdb.connect(host='127.0.0.1', db='myfamily',
user='root', passwd='Oracle11g')
cur = conn.cursor()
r = cur.execute('insert into people values(6,\'Bill Gates\',58,\'M\')')
cur.execute('delete from people where age=58')
conn.commit()
r = cur.execute('select * from people')
r = cur.fetchall()
print r
#!/usr/bin/python
#filename:pyMysql.py
#coding:utf-8
import MySQLdb
conn = MySQLdb.connect(host='127.0.0.1', db='myfamily',
user='root', passwd='Oracle11g')
cur = conn.cursor()
r = cur.execute('insert into people values(6,\'Bill Gates\',58,\'M\')')
cur.execute('delete from people where age=58')
conn.commit()
r = cur.execute('select * from people')
r = cur.fetchall()
print r