方法一:手动创建数据表模型类进行映射( 映射的表必须要有主键)
class Config():
SQLALCHEMY_DATABASE_URI = "mysql+pymysql://root:123456@localhost:3306/test_db?charset=utf8"
SQLALCHEMY_TRACK_MODIFICATIONS = False
- 使用show create table book1(book1是表名)查看创建表语句
- 对应book1的创建语句创建模型类,字段名、类型、约束需要一样,不然会报错
app = Flask(__name__)
class Config():
SQLALCHEMY_DATABASE_URI = "mysql+mysqlconnector://root:123456@localhost:3306/test_db?charset=utf8"
SQLALCHEMY_TRACK_MODIFICATIONS = False
app.config.from_object(Config)
db = SQLAlchemy(app)
class Book1(db.Model):
__tablename__ = "book1"
国家 = db.Column(db.String(254),default="null")
省份 = db.Column(db.String(254),default