回顾创建表格的代码:
from sqlalchemy import create_engine
from sqlalchemy import String, Integer, Column
from sqlalchemy.ext.declarative import declarative_base
#声明Maria引擎
engine = create_engine("mysql://root:mypassword@192.168.0.31/test", encoding="utf-8", echo=True)
Base = declarative_base()
#设定自增长主键
from sqlalchemy import Sequence
#User表的声明
class User(Base):
__tablename__ = 'users'
id = Column(Integer, Sequence('user_id_seq'), primary_key=True)
name = Column(String(50))
fullname = Column(String(50