Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- d=2017-10-01;
- while [ "$d" != 2017-12-08 ]; do
- f=$(date -d $d +%m%d);
- echo $d, $f;
- mysql -vv -e "load data infile '/home/www1/data/e$f.txt' ignore into table e17 LINES TERMINATED BY '\r\n'(ip,n,p,b,c,h) set dt='$d', i=inet_aton(ip)";
- d=$(date -I -d "$d + 1 day");
- done;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement