Working on a Thursday afternoon, I came across a problem where we had to return multiple counts (about 10 of them ) in an application. One way was to have multiple stored procedures and call them one by one, but this would mean I would have to make 10 connections to the database and 10 [...]
tags: MySQL author: admin comments: 7 Comments
Ever wonder how to scroll upwards in mysl resultset ? What if your terminal doesn’t allow scrollback or the scrollback buffer is somehow set to sreen lines ? How to use MORE or LESS unix commands in mysql which would allow to scroll using ‘return’ or ‘spacebar’ Follow the steps given below: [Invoke mysql using [...]
tags: Linux, MySQL author: admin comments: 1 Comment