Get the SQL query result without the table format

sql

mysql-flags

output-customization

batch-mode

byAnton Shumikhin·Jan 25, 2025

Aggregating SQL query results into a single text line is achievable by concatenating column values:

MySQL:

/* This is more of a CONCATi-party than a SELECT party 🎉 */
SELECT CONCAT_WS(', ', column1, column2, column3) AS line FROM your_table;

SQL Server:

/* SQL Server enjoys + symbol a lot! It's like a "+" in sugar! */
SELECT (column1 + ', ' + column2 + ', ' + column3) AS line FROM your_table;

PostgreSQL:

/* Ever heard of string_agg? The PostgreSQL's party trick! 🎩 */
SELECT string_agg(column_name::text, ', ') FROM your_table;

With these snippets, grid-like table layouts are replaced by comma-separated strings.

Power-of-mysql-flags

In MySQL, command-line options play a vital role in output customization.

The Swiss Army Knife: `-B` flag

The -B flag, or --batch, enables a non-tabular output format and implicitly enables --silent, reducing output messages:

/* The -B flag has more powers than your favourite superhero! 👊 */
mysql -u user -p -B -e "SELECT * FROM your_table"

`-s` and `-r` flags: The Dynamic Duo

To remove decorative frills from your output, utilize -s (silent) and -r (raw) flags. Used together, they offer non-escaped, nontabular output:

/* Silent but deadly efficient 💨 */
mysql -u user -p -s -r -e "SELECT * FROM your_table"

Execute & Exit Strategy: `-B` and `--execute` flags

Combine -B with --execute to run an SQL statement and exit:

/* Database version of 'hit and run' 💥 */
mysql -u user -p -B --execute="SELECT * FROM your_table"

This trick streamlines frequent SQL workflows, making your scripting journey more efficient.

Achieving Optimization in Your Outputs

Going Beyond with `-B`

The -B flag surpasses its regular duty by offering cleaner output, thus boosting the efficiency and readability of your scripts.

Tailored Outputs for Personal Use

Combine different flags to customize your output. Extra flag options are available to mold the query outputs to fit your specific needs.

Script-worthy Solutions

Harness the power of these flags within automated scripts or database tasks. They'll return clean output with reduced noise, a perfect match for automation.

explain-codes / Sql / Get the SQL query result without the table format

Linked

Mysql dump by query



How to convert all tables from MyISAM into InnoDB?



Store MySQL query output into a shell variable



Select from nothing?



Mysql: Get character-set of database or table or column?



Mysql combine two columns into one column



Sql Update from One Table to Another Based on ID Match



Power-of-mysql-flags Achieving Optimization in Your Outputs