pip install SQLAlchemy python from sqlalchemy import create_engine engine = create_engine('mysql://username:password@localhost/mydatabase') python from sqlalchemy.ext.declarative import declarative_base from sqlalchemy import Column, Integer, String Base = declarative_base() class User(Base): __tablename__ = 'users' id = Column(Integer, primary_key=True) name = Column(String) email = Column(String, unique=True) python from sqlalchemy.orm import sessionmaker Session = sessionmaker(bind=engine) session = Session() new_user = User(name='John Doe', email='johndoe@example.com') session.add(new_user) session.commit() users = session.query(User).all() for user in users: print(user.name, user.email) user = session.query(User).filter_by(name='John Doe').first() print(user.name, user.email) user.name = 'Jane Smith' session.commit() session.delete(user) session.commit()