Exporting Specific Columns,Specific Rows from a Specific Table of a Specific Database in Mysql -

i need export subset of columns large table containing large number of columns.also table contains million of rows want export specific rows table.

i have started using mysql earlier working on oracle.

this worked me:

mysql -u username --password=password --database=database \ --execute='select `field_1`, `field_2` `table_name`' -x > file.xml 

and importing file, using command:

load xml local infile '/pathtofile/file.xml'  table table_name(field_1, field_2, ...);