from sqlalchemy import create_engine 
from sqlalchemy.ext.declarative import declarative_base 
from sqlalchemy import Column,Integer,String 

engine = create_engine('mysql+pymysql://godme:godme@localhost/godme',encoding='utf-8',echo=True) 

Base = declarative_base() 

class User(Base): 
  __tablename__ = 'user' 
  id = Column(Integer,primary_key=True) 
  name = Column(String(32)) 
  password = Column(String(64)) 

__tablename__：指定表名
Column：行声明，可指定主键
Integer：数据类型
String：数据类型，可指定长度

Base.metadata.create_all(engine)