随笔分类 -  MYSQL

摘要：TERMINATED ：分隔符 ESCAPED ：转义用什么标示，‘’ 不设置转义符 LOAD DATA LOCAL INFILE '/home/tmp/1999/holder.csv' INTO TABLE 1999_holder CHARACTER SET utf8 FIELDS TERMINA 阅读全文

摘要：select a.REG_CN_NAME,a.REG_NUM,a.INT_CLS from T_FENFA_43_TM_HOLDERINFO a where a.REG_CN_NAME NOT REGEXP '[0-9]+' 阅读全文