MySQL Client and Connection Cheatsheet/Query without column headers

Print raw rows for scripts and pipelines.

Section: script-friendly client patterns

Query without column headers

bash
bash
mysql -u app_user -p -N -e "SELECT id, email FROM users LIMIT 5;" app_db
Explanation

`-N` removes column names from the output.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing script-friendly client patterns
Use batch mode for parsable output
Reduce formatting for machine-friendly results.
OpenIn sheetbashsame section
Log an interactive session to a file
Write statements and output to a transcript file.
OpenIn sheetsqlsame section
Show connection status in the mysql client
Display host, connection id, server version, and current database.
OpenIn sheetsqlsame section
Show active sessions
Inspect current client connections and statements.
OpenIn sheetsqlsame section
Kill a running connection
Terminate a session by connection id.
OpenIn sheetsqlsame section
Connect to a local MySQL server
Open an interactive mysql session.
OpenIn sheetbash1 tag match