Here is a diagram of sql joins for better understanding how they work. This visual representation contains following joins, Inner Join, Left Join, Right Join, Outer Join, Left Join excluding Inner Join, Right Join excluding Inner Join, Outer Join excluding Inner Join.
Sadupa Wijeratne
29 Articles
Sadupa Wijeratne is the founder of My Cute Blog. Currently working as a software engineer. Interested about latest technologies and love to learn by experience.
There are situations where you want to add your own .jar library as maven dependency. Also there are third party libraries which are not available in the central maven repository. In a situation like that you can add that .jar file in your local repository…
What if you lose your mobile? Have you ever thought about it? Just imagine someone steal your mobile. Not just the cost of your mobile think about the data in it. Your photo gallery, contacts, messages and all other private data are in danger. And…
Hope you have already used or at least seen smart TVs controlled by motion. It’s time to experience the same with laptop. HP has introduced a motion controlled laptop. This model is named as Envy 17 Leap Motion. According to HP this is the first…
How do you keep your day to day notes like TODO lists, web addresses or other small notes that you need to remember? Some people use sticky notes for this. Sometime you may be using text files. But managing them is not quite easy isn’t…
Here are some simple steps you can take to secure your WordPress login from hackers. WordPress is one of the most popular CMS(Content Management System) currently on the internet. Currently WordPress is used for thousands of websites around the world. A common problem faced by…
Are you worried about scratches on your mobile? Check the latest G Flex mobile from LG with a self healing body. Also this mobile has a curve shaped body which is flexible. Watch the following video for a full demo. You can find full phone specification…
If you have website with facebook like buttons you might have noticed new a design of facebook like button. With this update Facebook Send button is replaced with Share button. Good news is that there is no code modification to to be done on existing like…
Google has already announced that web site speed is one of the ranking factors in their ranking algorithm. Therefore all webmasters are trying to improve their web site loading speed as much as possible. Using a CDN(Content Delivery Network) is one method that you can…
Cron jobs help to run a script on a given interval. You can set a cron job to visit a web page on a given time. This article explains how to create a cron job easily in cpanel. First log in to cpanel and click…