from sqlalchemy import Table, MetaData, Column, Integer, String, ForeignKey # 导入元素 from sqlalchemy.orm import mapper # 导入映射关系 from sqlalchemy import create_engine engine = create_engine('mysql+pymysql://cai:123@localhost/test?charset=utf8', echo=True) metedata = MetaData(bind=engine) userTable = Table( 'user', metedata, Column('id', Integer, primary_key=True), Column('name', String(50), unique=True), Column('fullname', String(50)), Column('password', String(20), default='123') ) class User(object): def __int__(self, name, fullname, pwd): self.name = name self.fullname = fullname self.pwd = pwd mapper(User, userTable)#绑定映射 metedata.create_all(engine)