sqlalchemy使用2--创建表格

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()