SELECT INTO OUTFILE - Question

condoug

I have a query which is selecting a few fields from TABLE1 and dumping the results into a CSV file.

I then use LOAD DATA LOCAL INFILE to push that data into a new table called TABLE2. All works great up to this point.

My question is, that I need to ensure a unique hash is stored in TABLE2 with each fresh import so I know which rows to delete when I need to delete them. How can I get a unique value to be stored in my CSV file before it gets imported?

Thanks for your advice and help.

Derokorian

In your select statement you can add a column, like the following:

SELECT firstcol, secondcol, thirdcol, SHA1(NOW()) FROM myTable WHERE ....

__ OR __

SELECT *, SHA1(NOW()) FROM myTable WHERE ....