i uploading csv file via load data infile command in bash script. need find out how many lines of data uploaded. need know compare number of lines in csv.
this verify data mentioned in csv file uploaded. using bash script upload excuted on bi-hourly everyday.
how can number of rows uploaded.
mysql -u $_db_user -p$_db_password -d $_db --local-infile=1 <<eof load data local infile '$_csv_directory/tempimport.csv' table tempimport fields terminated ',' enclosed '"' lines terminated '\r\n'; eof
Comments
Post a Comment