记录-方便以后遇到查看:
- mysql
UPDATE dealer_mostly SET BACKMODULE = CONCAT(BACKMODULE,'aa') WHERE DM_NUM = '100011'
- orcle
CONCAT()
- sql server 用 +
- mysql 实现orcle序列 形式: (@rownum:=@rownum+1) AS rownum
记录-方便以后遇到查看:
UPDATE dealer_mostly SET BACKMODULE = CONCAT(BACKMODULE,'aa') WHERE DM_NUM = '100011'
CONCAT()