from sqlalchemy import Column,String,create_engine,ForeignKey,MetaData,Table,Integer
from sqlalchemy.orm import sessionmaker,relationship
from sqlalchemy.ext.declarative import declarative_base
#连接数据库
engine = create_engine('mysql+mysqlconnector://root:password@localhost:3306/test')
metadata = MetaData(engine)
#创建表格
users_table = Table('users', metadata,
Column('id', Integer, primary_key=True),
Column('name', String(40)),
Column('email', String(120)))
users_table.create()
sqlalchemy使用2--创建表格
最新推荐文章于 2021-04-10 18:06:42 发布