export table to csv file

 mysql -uroot -psmkslb HtipDB -e "select * from nodes_log" -B > mytable.csv

SELECT * FROM users
  INTO OUTFILE '/tmp/users.csv'
  FIELDS TERMINATED BY ','
  OPTIONALLY ENCLOSED BY '"';