Iterating through a huge number of records to display as HTML or to send to client applications over REST/JSON or SOAP/XML is a huge processing effort for the application server. Read more to know how to delegate such processor-intensive work to DB server running MySQL
Principle and Principal sound similar but spell differently i.e., they have identical phonetics but not the spelling. The same is case with ball and boll and many other words. Read more to check how to compare database entries based on phonetics instead of spellings on the DB server running MySQLRead More →
In some cases, we have to form a string out of multiple records in the database. For example Consider we are working on a blog site where a post shall have many tags for it, we just need to display all of them under post separated by a space.Read More →
Displaying different fields based on null. For example, after user logged into our site, we have to display user actions in our site menu where if a user has alias and name both we just have to show alias if he has no alias you have to show name.Read More →