mysql -u ###SQL_USERNAME### -p###SQL_PASSWORD### database -e "LOAD DATA INFILE '$data_file' INTO TABLE database.table_name IGNORE 1 LINES (@nouse,ym,DNS_AMOUNT,DNS_PM)
SET PM_DATE = '$file_date',PARTID = '$file_day'"
//默认以"\t"分隔的字段
mysql -u ###SQL_USERNAME### -p###SQL_PASSWORD### database -e "LOAD DATA INFILE '$data_file' INTO TABLE database.table_name FIELDS TERMINATED BY ',' (YM,PARTID) "
//以逗号分隔的字段
SET PM_DATE = '$file_date',PARTID = '$file_day'"
//默认以"\t"分隔的字段
mysql -u ###SQL_USERNAME### -p###SQL_PASSWORD### database -e "LOAD DATA INFILE '$data_file' INTO TABLE database.table_name FIELDS TERMINATED BY ',' (YM,PARTID) "
//以逗号分隔的字段