mysql - How to find the rows uploaded via Load Data Infile command -


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