ause: java.sql.SQLException: Field 'id' doesn't have a default value ### The error may involve com.miaoshaproject.dao.UserPasswordDOMapper.insertSelective-Inline ### The error occurred while setting parameters ### SQL: insert into user

ause: java.sql.SQLException: Field 'id' doesn't have a default value ### The error may involve com.miaoshaproject.dao.UserPasswordDOMapper.insertSelective-Inline ### The error occurred while setting parameters ### SQL: insert into user_password ( enc

来源：3-11 用户模型管理--用户注册功能实现02

杭电鬼先生

2019-01-21 20:37

ause: java.sql.SQLException: Field 'id' doesn't have a default value ### The error may involve com.miaoshaproject.dao.UserPasswordDOMapper.insertSelective-Inline ### The error occurred while setting parameters ### SQL: insert into user_password ( enc

写回答关注

1回答

杭电鬼先生

2019-01-21 20:43:31

就是user_info和user_password两张表的id都要设置自增长,打扰了

1 0

lastli...

在可视化工具里已经设置了两张表的id自增，还是会报这个错误

2019-01-28 15:10:53

共 1 条回复 >

SpringBoot构建电商基础秒杀项目

应用SpringBoot快速搭建拥有用户、商品、交易及秒杀活动的电商秒杀应用。

49065 学习 · 954 问题

查看课程

相似问题

Field 'id' doesn't have a default value]

回答 1

''user_id' doesn't have a default value

回答 2

java.sql.SQLException: connect error, url jdbc:mysql//127.0.0.1:3306/miaosha, driverClass com.mysql.jdbc.Driver

回答 1

Some problems were encountered while building the effective settings

回答 1

insert 数据后，“user_password”表的user_id为0

回答 3

打开慕课网App查看更多内容