日期:2014-05-16 浏览次数:20414 次
\0 ASCII 0 (NUL ) 字符 \' ASCII 39 单引号 (“'” ) 字符 \" ASCII 34 双引号 (“"” ) 字符 \b ASCII 8 退格符 \n ASCII 10 换行符 \r ASCII 13 回车符 \t ASCII 9 制表符(TAB )
查询字段是否存在tab制表符: select * from crm_special_link t where instr(t.link_number,chr(9))>0 替换空格、tab制表符: update crm_special_link set link_number = replace(link_number,' ',''); update crm_special_link set link_type = replace(link_type,' ',''); update crm_special_link set link_number = replace(link_number,chr(9),'');