Kulpakji - kcg : 040 - 27562545, 66362545

Koti bhojansaala : 040 65875860
charkaman, gulzar house, hyd : 24526308, 9290006318

jaingurukul.org

Have the Brain with Fun

Here u can find some scientifically designed games , fun to reclaim brain

Replace the Column Contents using Update/Replace Query in Database

Consider a situation, that needs to modify some string part of a column in a table with a large amount of rows.

For such situations, manually modifying the database (by taking the dump of the table and changing the queries in the dump with editor by find and replace the column content) , would be a hectic process:-(. For that there is a simple Query to update and replace the part of the column content. Following is the syntax with example:

UPDATE table_name SET column_name = REPLACE(column_name,”original_string”,”replace_string”)[/sql]

Here is what I did to change the path URLs in all the previous posts.
[sql]UPDATE `wp_posts` SET `post_content` = REPLACE(`post_content`,”mydummysite.com/wp”,”tinytip.blogspot.com/blog”)[/sql]

Difference : Developer or Programmer

Developer and Programmer , the two words generally seen in the pages for some job profiles etc.. Then what is the exact difference between the two. As far as my knowledge says,

A Programmer is who writes the instructions in the language for the target of compilation and execution of the task, mostly if the better one would test for any bugs.

A Developer also includes programmer in himself as a start step. A Developer, has following the additional tasks....as follows:


* Spec documents
* Configuration management
* Code reviews
* Testing
* Automated tests
* Documentation
* Solving tough customer problems



So in aside of this concept, it can also be concluded as small independent software vendors tends to require developers rather than Programmers.

A good explaination of this one can be found here

ScreenShots using iPhone , without any app

Just Press Home button and Sleep/PowerOff button simultaneously.
You will get a flash on the iPHone screen and screenshot will be saved on the iPhoto library of the iPhone.

To view the screenshots on the mac os x, connect the iPHone to MAC OS X and open iPhoto App ,

Applications->iPhoto.app

select the iPhone menu on the left and follow the required instructions to import, or edit etc...

Display CopyRight on your image using Gimp

Displaying the CopyRight on an image using Gimp is very easy using the plugin Eg-CopyRight

Download the Plugin and add it to folder C:\Program Files\GIMP-2.0\share\gimp\2.0\scripts

Now Restart the Gimp,
Open image on which copyrights are to be displayed.
Go to Filters->Eg->CopyRight and enter the requirements.

Combine multiple images using Pandora

Using gimp , it is possible to combine multiple images, using Pandora Plugin

Add the plugin to C:\Program Files\GIMP-2.0\share\gimp\2.0\scripts folder and Restart Gimp.

Now in File->Open as Layers ,
Select multiple images to be made into one .
Now Go to Filters->combine->Arrange as Pandora and follow the instruction it gives.