posted 11 years ago
This is something related to MYSQL database.
I have a query which loads CSV file from some specified location on the server. query reads all the data and retrieves them to store as individual records in mysql table.
so the number of rows in the csv file will be inserted into the mysql table as same number of records.
My problem (or say requirement) is to get the row id of each csv record. I have to get that row id / Row number / Row Index of that record, save it in my table.
want that row id to match with the corresponding record which gets inserted into the table.
so when I cross check the specific row number in my csv file and the Row id column data in the table, they should match.
Note: Some times row get skipped from inserting into the table
for example :
if i have row id 30 in my csv file having values "Vinay","Hyderabad","India"
My table should contain 30 Vinay Hyderabad India as row values.
How do I do that?
Thanks in advance for your answers....