UPDATE employees SET NAME= CONCAT(NAME,‘(已删除)‘),IsDeleted=TRUE WHERE CompanyID=‘2‘
Mysql 小技巧
原文:https://www.cnblogs.com/xinyibufang/p/9054820.html