正文
Mysql load data infile 命令格式
小程序:扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序
【扫一扫了解最新限行尾号】
复制小程序
【1】Linux系统环境下
LOAD DATA INFILE /usr/LOCAL/lib/ubcsrvd/datacsv/201909_source.csvINTO TABLE np_cdr_201909 FIELDS TERMINATED BY ','IGNORE LINES (product_id, calling_id, start_time, duration, call_type, @fee),insert_time = SYSDATE(),np_id = 'abdefg',cdr_state ',source = 'kaizenly';
【2】Windows系统环境下
LOAD DATA INFILE 'C:/Users/Administrator/Desktop/201909/201909_source.csv'INTO TABLE np_cdr_201909 FIELDS TERMINATED BY ','IGNORE LINES (product_id, calling_id, start_time, duration, call_type, @fee),insert_time = SYSDATE(),np_id = 'abdefg',cdr_state ',source = 'kaizenly';
Good Good Study, Day Day Up.
顺序 选择 循环 总结