update table set 字段1=CONCAT(字段1,'$增加内容变量') where id='324'
这是CONCAT的用法:
CONCAT(str1,str2,...)
Returns the string that results from concatenating the arguments. Returns NULL if any argument is NULL. May have more than 2 arguments. A numeric argument is converted to the equivalent string form: