mysql

 

 

#!/usr/bin/env python
# encoding: utf-8

'''
@author: Colin
'''
import MySQLdb

conn=MySQLdb.connect(host='192.168.1.4',user='root',passwd='chenke1987',db='colin')
cur=conn.cursor()

# 增

# reCount=reCount = cur.execute('insert into test(uid,uname,upassword) values(%s,%s,%s)',(1,'zhangxiaoben','123'))

# reCount=reCount = cur.execute('insert into test(uid,uname,upassword) values(%s,%s,%s)',(2,'colinchen','123'))

#删
# reCount = cur.execute('delete from test WHERE uid=1')

#改
# reCount = cur.execute('update test set uname = %s',('colinchen2',))

#查
sch= raw_input("input schema:").strip()
print(sch)
reCount = cur.execute('select * from '+sch)
# print cur.fetchone()

print(cur.fetchall())

conn.commit()
cur.close()
conn.close()