December 18th, 2008 () MySQL › admin › 7 Comments
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 [...]
October 16th, 2008 () Linux, MySQL › admin › 1 Comment
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 [...]
August 10th, 2008 () General › admin › No Comments
Welcome to the world of LAMP. For all you disgraceful people who don’t know what it is, the definition: L = > Linux ( Its an operating system ) A => Apache ( Its a web server ) M => MySQL ( Its a database system ) P => PhP {&perl } ( These are [...]