update table set field=concat(' ', field, '072110003') where field='072110001';
åºè¯¥æ¯
update table set field=concat_ws(' ', field, '072110003') where field='072110001';
æè
update table set field=concat(field, ' ', '072110003') where field='072110001';
对äºéè¦ä¸æ¬¡æ·»å å¤ä¸ªå¼ï¼å¹¶ä¸é½ç¨' 'éå¼çè¯ï¼ç¨ç¬¬äºæ¡è¯å¥æ¯è¾æ¹ä¾¿ã ä¸æ¬¡åªç¨ä¸ä¸ªçè¯ï¼concatæ¯è¾ç®åèä¸ä¸åæ°æ®åºéç¨ã
温馨提示:内容为网友见解,仅供参考