cat test.sql | mysql --local-infile=1 -usuperuser -p... echo "SELECT * FROM dbname.tabname LIMIT 12;" | mysql -t +----+-------------------------------------+-------+ | id | pwhash | count | +----+-------------------------------------+-------+ | 1 | 001C6CE64AFA01E95015ABAE848E45F6E01 | 4 | | 2 | 001C6CE64AFA01E95015ABAE848E45F6E02 | 4 | | 3 | 001C6CE64AFA01E95015ABAE848E45F6E03 | 4 | | 4 | 001C6CE64AFA01E95015ABAE848E45F6E04 | 4 | | 5 | 001C6CE64AFA01E95015ABAE848E45F6E05 | 4 | | 6 | 001C6CE64AFA01E95015ABAE848E45F6E06 | 4 | | 7 | 001C6CE64AFA01E95015ABAE848E45F6E07 | 4 | | 8 | 001C6CE64AFA01E95015ABAE848E45F6E08 | 4 | | 9 | 001C6CE64AFA01E95015ABAE848E45F6E09 | 4 | | 10 | 001C6CE64AFA01E95015ABAE848E45F6E10 | 4 | +----+-------------------------------------+-------+