在你做web项目时,如果在做登录注册功能,注册导入数据库,碰到了以下的难题,请先给我点个赞
sqlalchemy.exc.IntegrityError: (MySQLdb._exceptions.IntegrityError) (1364, "Field 'id' doesn't have a default value")
[SQL: INSERT INTO user (nickname, login_name, login_pwd, login_salt, updated_time, created_time) VALUES (%s, %s, %s, %s, %s, %s)]
[parameters: ('222222', '222222', 'ad297f4842bfd9eb42fa1584a4b0f6f2', 'XJCsnsza', '2022-06-10 21:38:31', '2022-06-10 21:38:31')]
(Background on this error at: https://sqlalche.me/e/14/gkpj)
解决方案:
将自增点上就行了,就是第一行第三个√
(感觉好离谱啊,让我查了半小时)