python连接mysql并进行操作代码

#python连接mysql代码

conn = MySQLdb.Connect(
	host = "192.168.146.128",
	port = 3306,
	user = "root",
	passwd = "123456",
	db = "imooc",
	charset = "utf-8")

curosr = conn.cursor()
print conn
print cursor
cursor.close()
conn.close()

#select查询数据库

import MySQLdb

conn = MySQLdb.Connect(
	host = "192.168.146.128",
	port = 3306,
	user = "root",
	passwd = "123456",
	db = "imooc",
	charset = "utf-8")

curosr = conn.cursor()
sql = "select * from user"
try:
	cursor.execute(sql)
	print cursor.rowcount
	rs = cursor.fetchone()
	print rs	
	rs = cursor.fetcmany(3)
	print rs
	rs = cursor.