[Derision]

mysql -u root

use eq;
tee items.txt
select id,name from items;
quit

that will write the id and name field for each item to items.txt

Is that what you are after ?