new to mysql.. i have a simple database that is to contain 4 fields :
filename, filesize, crc32, csvname
The csv contains the first 3 fields, and i want to add the csv filename
into the 4th field somehow.
Using LOAD DATA INFILE i am able to fill the first 3 fields but i cannot figure out how to fill the 4th field.
I have over 7000 csv files so ultimately i wish to create a script that reads each csv, loads the data, and adds the csv filename into the 4th field.
Could you point me in the right direction please ?
Your help is appreciated !