苦苦思索的吃瓜群众博客

2059, “Authentication plugin ‘caching_sha2_password’ cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory” 今天用sqlalchemy连接mysql8.0数据库，一直报错，记录下解决方案 系统默认密码模式是caching_sha2_password 如需修改

使用sqlalchemy建表和增删改查 sqlalchemy建表 from connect import Base,session from sqlalchemy import Column,Integer,String,DateTime,Boolean from datetime import datetime class User(Base): __tablename__=...

sqlalchemy带条件查询 filter_by与filter filter_by 与filter的区别： 1. filter_by只能取值= filter可以==，!=,>=,<=等多种取值方式 2. filter带参数必须表名.字段名 User.username #带条件查询 # print(session.query(User).filter_by(use...

sqlalchemy连接数据库 安装pymysql pip install pymysql 安装sqlalchemy pip install sqlalchemy 连接数据库 ''' this is sqlalchemy ''' from sqlalchemy import create_engine HOSTNAME = '192.168.31.105' PORT = ...