Taking dump of query result into file

I have users table in  my database and If you want to take all user rows data into file, then execute below query..

SELECT id,user_name, address into OUTFILE  ‘d://userdbdump.txt’ FIELDS TERMINATED BY ‘,’ FROM users