Does the mysql CLI tool provide a way to display binary data in a console-friendly manner?

mysql console binary-data
Richard Simões picture Richard Simões · Mar 23, 2012 · Viewed 8.4k times · Source

I have a MySQL database containing a table with a binary-typed column. I'd like to be able to project that column without having to run it through, e.g., HEX(). Does the mysql CLI tool have a configuration option or other means to display a representation of binary data in a manner that won't output arbitrary bytes for my console to interpret in hilarious/annoying ways?

Answer

Pradeep picture Pradeep · Apr 9, 2018

Start MySQL CLI with param --binary-as-hex

Example:

mysql --binary-as-hex

Related questions

Error in MySQL when setting default value for DATE or DATETIME

I'm running MySql Server 5.7.11 and this sentence: updated datetime NOT NULL DEFAULT '0000-00-00 00:00:00' is not working. Giving the error: ERROR 1067 (42000): Invalid default value for 'updated' But the following: updated datetime NOT NULL DEFAULT '1000-01-01 00:00:00' …

Read More
Autocompletion in the MySQL command-line client

In Linux, and many other systems, when navigating the terminal you can press Tab to auto complete a directory or file name. I'm wondering if there is anything like that in the MySQL terminal. For example, if I want to …

Read More
Selecting a database in mysql with spaces in its name

I want to select my particular database in mysql console, but the problem is that my database name has a space in between and mysql ignores the part after the space. For instance, when i give the command: use 'student …

Read More