前提安装相关库
pip install mysqlclient (Windows)
import MySQLdb import os def CaseTable(case1): db = MySQLdb.connect("localhost", "root", "root", charset='utf8')#连接数据库,root分别为账号和密码 # 使用cursor()方法获取操作游标 cursor = db.cursor() sql = "show databases" cursor.execute(sql) results = cursor.fetchall() re = list(results) #获取所选择的库中的表的数据 case=case1 if case == case1: sql = "use "+re[int(case1)][0] cursor.execute(sql) cursor.execute("show tables") result = cursor.fetchall() re1 = list(result) for i in range(len(list(result))): print(i,list(result)[i][0]) choose = input('请选择查看哪一表中的内容:') #查看表中数据 sql1 = "select * from "+re1[int(choose)][0] print(sql1) cursor.execute(sql1) cc = cursor.fetchall() for i in range(len(list(cc))): print(list(cc[i])) #更新表中password数据 print('更新后台密码:update '+re1[int(choose)][0] +' set password=') print('注意:密码需要用对应的加密方式') password = input('') print('更新后台密码:update '+re1[int(choose)][0] +' set password='+password+' where id=') id = input('') update = 'update '+re1[int(choose)][0] +' set password='+password+' where id='+id cursor.execute(update) result = cursor.fetchall() print('更新后台密码:update '+re1[int(choose)][0] +' set password='+password+' where id='+id) print('更改成功') def main(): db = MySQLdb.connect("localhost", "root", "root", charset='utf8') # 使用cursor()方法获取操作游标 cursor = db.cursor() # 使用execute方法执行SQL语句 sql = "show databases" cursor.execute(sql) #fetchall()方法获取所有返回的结果 results = cursor.fetchall() re = list(results) for j in range(len(re)): print(j ,re[j][0]) case = input('请选择查看哪一数据库中的表') CaseTable(case) db.close() if __name__ == '__main__': main()
整体运行如下,脚本略水,如图所示可以更改数据,并查询所有数据库中的相关信息(缺点:只针对password数据进行快速更改)

