update loan set keyinfostate = ? and applyModifyContent = ? where id = ?
报的错误是:Data truncation: Column set to default value; NULL supplied to NOT NULL column 'keyinfostate' at row 1
已解决
SQL问题(update), 请大神帮忙解决!
答案:3 悬赏:0 手机版
解决时间 2021-12-22 11:00
- 提问者网友:溺爱和你
- 2021-12-21 18:38
最佳答案
- 五星知识达人网友:雪起风沙痕
- 2021-12-21 19:35
要使用这样的update格式:
update loan set keyinfostate = 'ABC ' where id = 'AAA';
update loan set applyModifyContent = 'DEF' where id = 'AAA';
update loan set keyinfostate = 'ABC ' where id = 'AAA';
update loan set applyModifyContent = 'DEF' where id = 'AAA';
全部回答
- 1楼网友:撞了怀
- 2021-12-21 21:49
select fyp from b where wrcvdate between 2013-08-01 and 2013-08-31
- 2楼网友:蓝房子
- 2021-12-21 21:14
非空的列却给了空值
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯