python连接mysql并进行操作代码

来源：互联网发布：网络语ATM 编辑：程序博客网时间：2024/06/05 00:11

#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 connprint cursorcursor.close()conn.close()

#select查询数据库

import MySQLdbconn = 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.rowcountrs = cursor.fetchone()print rsrs = cursor.fetcmany(3)print rsrs = cursor.fetcall()print rsexcept Exception as e:print econn.rollback()cursor.close()conn.close()

#insert/update/delete操作

import MySQLdbconn = MySQLdb.Connect(host = "192.168.146.128",port = 3306,user = "root",passwd = "123456",db = "imooc",charset = "utf-8")curosr = conn.cursor()sql_insert = "insert into user(userid, username) values(10, 'name10')"sql_update = "update user set username = 'name91' where userid = 9"sql_delete = "delete from user where userid < 3"try:cursor.execute(sql_insert)print cursor.rowcountcursor.execute(sql_update)print cursor.rowcountcursor.execute(sql_delete)print cursor.rowcountexcept Exception as e:print econn.rollback()cursor.close()conn.close()

0 0