You must have fired those select statements tons of times. So you hit a query, get your results and you are done. But what if the next day you felt like going through the results you found the other day. Simple..hit the query again. But what if the query was complex and you need the results fast. What you shud have done in the first place was to generate a CSV file out of your query result.
The way I do it and others must be doing is pretty simple.
So say your query was something like this:
mysql> select * from users where dob > ‘1981-10-07’;
To get the output of this query into a CSV file is pretty simple. Do dis….
mysql> select * from users where dob > ‘1981-10-07’
INTO OUTFILE ‘user_details.csv’ FIELDS TERMINATED BY ‘,’
LINES TERMINATED BY ‘n’;
Bingo..u have ur file waiting for u. In case u don’t know where that file got created…check in dis location:
So its dat very simple. So next time just keep this in mind.
And though this is off topic, here is a way to add time to a datetime attribute in your table.
mysql> select batchid, date_add(created_at, interval ‘9:30’ HOUR_MINUTE)
from batches where created_at >= ‘2000-01-01 00:00:00’ and created_at <= ‘2000-01-02 01:00:00’ ;
Simple enough. 🙂