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