摘要:
1.首先定义注册类RegisterEntity [Serializable] public class RegisterEntity { public string RegisterKey; public bool IsRegistered; public List<int> RegisterOrd 阅读全文
摘要:
随机RAND() 选择判断select if 例:select if(consignment=0, '否','是') 条件选择case when ... then end 例:case supplierType when 1 then '准目录供应商' when 2 then 'sourcing供应 阅读全文
摘要:
单表查询: like模糊匹配 例: name like '%keyword%',全模糊匹配 name like 'keyword%',后模糊匹配 字段取别名as distinct过滤字段重复数据行 select distinct name from table select distinct nam 阅读全文