解决Data truncation: Truncated incorrect DOUBLE value: 'xxxxxxx';
出错语句:
DELETE FROM shuidi_dev.insurance_consumer WHERE user_no=<@UserId>;
原因:
查看表设计
坑在此处,在其他表这个字段叫做user_id是bigint类型的,在这个表中这个字段叫做user_no ,类型是varchar
更正后:
DELETE FROM shuidi_dev.insurance_consumer WHERE user_no='<@UserId>';