Mega Code Archive

 

Categories / MySQL / Table Index

 

The -e option specifies the query to execute, and -N tells MySQL not to write the row of column names that normally precedes q

% mysql -e "SELECT account, shell FROM passwd" -ss myDatabase > shells.txt