Posts

Service Engineer/System Administrator Interview Questions

This is not my code alone.  It was the group effort of Vivek Ram, Cijo George, Sandeep Unni and mine during our epic preparation for Yahoo!. I am just putting it open for others who would be looking for this information. Convert all lower case to upper  …

Generate 1 to 1000 in mysql

Sometimes its necessary to have thousand rows to join or generate new values, we need to get the thousand rows first. For this I used union of numbers 0-9.  I have joined four of these to get to four digit values. So here is the code:



SELECT @row := …

Operator Preference Grouping Order in C

Here is a compilation of how the preference of operators are Left to Right grouping or Right to Left grouping in C. Level Operator Description Grouping 1 :: scope Left-to-right 2 () [] . -> ++ — dynamic_cast static_cast reinterpret_cast const_ca …

More than 100% CPU in top in Linux/Mac

If you are power linux/mac user you should have noticed at least once that top shows more than 100% CPU for a process. I also have seen this multiple times but always wondered how it can be. Here is an example of how my top looked when I started my java an …

Create a table like another table or from a select query

There are some cases where we need to create a table similar or exactly same as another table. The easiest and best way is use create table along with additional parameters. We can create a table similar to another table without data and with data. Creat …