March 13, 2010

Rendering MySQL query results in vertical format

Database,

Easily reviewing SELECT query results in a shell window can be particularly difficult when a table consists of numerous columns. Remedying this inconvenience is easily done by appending the \G...

Read more
December 26, 2009

Converting MySQL query results into a CSV file

Database,

To dump data from the database into an Excel file, SELECT query can be used to convert data to CSV formatting. Converting MySQL query results into a CSV file All...

Read more
December 26, 2009

How to change the client prompt in MySQL?

Database,

Change MySQL's prompt by using the prompt command: mysql>prompt mysql (\d)> Once executed, the currently selected database will appear in the prompt, like so: mysql (mydatabase)> It's also easy to...

Read more