摘要：mysql> ALTER USER 'gao'@'%' IDENTIFIED WITH mysql_native_password BY '123456'; 修改用户密码 阅读全文

摘要：>>>cur.execute("update users set username=%s where id=2",("mypython")) >>>cur.execute("select * from users where id=2") >>>cur.fetchone() >>>conn.comm 阅读全文

摘要：>>>cur.execute("select * from 表名") >>>lines=cur.fetchall() >>>for line in lines: print(line) >>>cur.scroll(1) 游标上移一个位置 阅读全文

摘要：1、cmd pip3 install PyMySQL2、>>>import pymysql3、mysql>create database bookdb character set utf8;4、>>>conn=pymysql.connect(host='localhost',port=3306,us 阅读全文