sql 字符串连接 



const string FMCG_BASH = "清除重复商品";


1             var sqls = new List<string>();
2             //// Fmcg
3             sqls.Add(string.Format(@"UPDATE base_fmcg SET `Status`={0},Remark = CONCAT(IFNULL(Remark,''), ';', {2}) WHERE ID='{1}';"
4                 , Constants_StatusCode.dBRowStatus_Deleted
5                 , _p2
6                 , FMCG_BASH));




字符串连接：Remark = CONCAT(IFNULL(Remark,''), ';', {2})
const：常量,具有不可变性






            

            
posted @ 
2018-05-15 09:29 
墨竹daisy 
阅读(301) 
评论(0) 
编辑 
收藏 
举报