MySQL中修改多个数据表的字段拼接问题

错误1：

异常：Truncated incorrect DOUBLE value: 'lili'

 问题分析：我的修改sql语句是：update video set vname='汉字' and vdirct='xxx' and vprice='23' where vid=3

所以SQl报错：Truncated incorrect DOUBLE value: 'lili'

错误2：    update sort set num = " + num + " , zt = '1' ";
改为：update sort set num = "' + num + "' , zt = '1' ";