#MySQL command line client displays sql results in #OrgMode compatible format. 😍
@stefan
#+BEGIN_SRC emacs-lisp(require 'ob-sql)(setq dbpw "password")#+END_SRC#+BEGIN_SRC sql :engine mysql :database db :dbhost localhost :dbuser root :dbpassword (print dbpw) :exports results :cmdline --protocol=tcpshow databases#+END_SRC
@stefan
#+BEGIN_SRC emacs-lisp
(require 'ob-sql)
(setq dbpw "password")
#+END_SRC
#+BEGIN_SRC sql :engine mysql :database db :dbhost localhost :dbuser root :dbpassword (print dbpw) :exports results :cmdline --protocol=tcp
show databases
#+END_SRC