生成UPDATE语句整型赋值问题

浏览:665 发布日期:2016/10/13 分类:ThinkPHP5专区
[ sql ] [ SQL ] UPDATE `hm_ymusers`  SET `type`='A0002',`account`='654564',`name`='188884445445',`tel`='18888888887',`pnl`='',`email`='',`id_card`='XXXXXX',`id_province`='G0017',`id_city`='G0209',`id_district`='G1873',`id_address`='ffdsafdsa',`sex`=1,`province`='G0002',`city`='G0038',`district`='G0410',`address`='dfsdfs',`academic`='D0001',`birthday`='1986-04-18',`infact_day`='2016-09-30',`full_day`='2016-10-30',`nation`='H0001',`marry`=0,`slsort`='B0001',`dept`=0,`dept_mk`=1,`post`='',`leave_mk`=1,`ss_status`=3,`ss_no`='',`fund_status`=3,`fund_no`='',`parent_id`=0,`counselor`=,`bank`='',`bank_no`='',`back_bank`='',`back_bank_no`='',`waycard`='E0001',`local_mk`=0,`liaise_name`='',`liaise_tel`='',`liaise_address`='',`agency_no`='',`agency_valid`='0000-00-00',`login_level`=3  WHERE  `uid` = 21  AND `yymm` = '201606'                                                  
[ RunTime:0.081932s ]
上面是我从日志截取的,保存不成功! counselor 这个字段是mediumint型,前台传入数据是counselor = '',但是TP5.0.1生成的却是`counselor`=
最佳答案
评论( 相关
后面还有条评论,点击查看>>