| Dec 18 |
Archive for the 'MySQL' CategoryMultiple SQL Queries in a Stored Procedure.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 opens , 10 closes, phew !
So I decided to combine all of them into one:
|
| Oct 16 |
Archive for the 'MySQL' CategoryPagination in mysql CLIEver 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:
This also works under the unix ’screen’ terminal emulation |