随笔分类 - sql
摘要：select left(substring('p1111',help_topic_id+1),1) as num from mysql.help_topic where help_topic_id < length('p1111') select substring_index(substring_
阅读全文
摘要：LOCATE(substr,str) select a.name from tb_xs a where a.name like concat(a.name2,'%')
阅读全文
摘要：查看哪些字段重复和重复几次 select dwmc,count(*) as c from table_dw group by dwmc having c>1 显示重复字段的所有信息 select *from table_dw where dwmc in (select dwmc from table
阅读全文
摘要：select b.id,b.dwmc,f.id,f.ORG_NAME,f.FILE_TYPE from tb_casq b LEFT JOIN tb_bid_file f on f.OWN_CODE= b.id where b.id='25a4d7fe020f628e93953881d56f03bf
阅读全文
