Use Bat as pager for MySQL

[ggMartinez]

Hi guys!

I want to use Bat as a pager for mysql console.

I specify the SQL language, and it kidna works, but it's not accurate. For example, if a cell in a query has a quote character (for example, a name D'Argtanan) it brokes up because there is no closing quote.

Is there any language that works better for mysql?

[keith-hall]

Hi, can you give a more complete example please? Then it might be easier for us to investigate and suggest something 🙂

[michaelblyons]

This sounds to me like OP wants to highlight the ASCII- (or pipe-?) formatted result table output of a SQL query. See screenshot (source).

Once upon a time, I made something similar for a slightly different table format in Vim.