I have a very large database and I want to select certain records and then set a column value such as:
SELECT name, email FROM table WHERE zipcode = 12345 INTO outfile /tmp/file.csv;
Then I want to set the
mail_flag equal to today's date such as
SET mail_flag = 09012013
I'm just not sure how to string this together.