#/bin/sh
#awk '{print $1,$3,$4}' /home/dujy/masen/rwz/tmp_log_click.log>/home/dujy/masen/rwz/ren.log
awk '{OFS = "\t";print $1,$3,$4}' /home/dujy/masen/rwz/tmp_log_click.log > /home/dujy/masen/rwz/ren.log
/usr/local/mysql/bin/mysql -uroot -proot vote -e "LOAD DATA LOCAL INFILE '/home/dujy/masen/rwz/ren.log' into table renwenzhi(date,click,sid)"
#awk '{print $1,$3,$4}' /home/dujy/masen/rwz/tmp_log_click.log>/home/dujy/masen/rwz/ren.log
awk '{OFS = "\t";print $1,$3,$4}' /home/dujy/masen/rwz/tmp_log_click.log > /home/dujy/masen/rwz/ren.log
/usr/local/mysql/bin/mysql -uroot -proot vote -e "LOAD DATA LOCAL INFILE '/home/dujy/masen/rwz/ren.log' into table renwenzhi(date,click,sid)"