python学习--MySQLdb

#!/usr/bin/env python
#coding=utf-8
#MySQLdb属于第三方模块,需要自己安装

import MySQLdb

#连接数据库
conn = MySQLdb.connect(host='192.168.233.128', user='panda', passwd='panda55',db='test', port=3306)

#获取游标
cur  =conn.cursor()

#执行sql语句
cur.execute('show databases')
#fetchall获取返回值
for data in cur.fetchall():
    print 'database> '+'%s' %data
print


#创建数据表
cur.execute('create table users(login VARCHAR(8), uid INT)')

#显示当前数据库中的行(表)
cur.execute('show tables')
for data in cur.fetchall():
    print 'table> '+'%s' %data
print

#显示users表中的列
cur.execute('desc users')
for data in cur.fetchall():
    print 'colum> '+'%s\t %s\t %s\t %s\t %s\t %s'%data
print

#往users表插入数据
cur.execute("insert into users values('john',7000)")
cur.execute("insert into users values('jane',7001)")
cur.execute("insert into users values('bob',7200)")

#查询记录
cur.execute("select * from users")
for data in cur.fetchall():
    print 'insert> '+'%s\t%s' %data
print


#表记录修改
cur.execute("update users set uid=7100 where uid=7001")
cur.execute("select * from users")
for data in cur.fetchall():
    print 'modify> '+'%s\t%s' %data
print

#删除指定记录
cur.execute('delete from users where login="bob"')
#查询记录
cur.execute("select * from users")
for data in cur.fetchall():
    print 'delete> '+'%s\t%s' %data

#删除数据表
cur.execute('drop table users')

#关闭游标
cur.close()

#关闭用户连接
conn.close()