mysql -t -e 'SELECT * FROM users LIMIT 5;' mydb

Category: Databases & SQL

mysql -t -e 'SELECT * FROM users LIMIT 5;' mydb

Show query results as an ASCII table

Non-interactive mysql prints tab-separated rows by default; -t forces the boxed table format. Handy when you want readable output in a script. Related: -B for batch mode.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.