MySQL Cheat Sheet

Usually we use MySQL for coding our database in our project. What if you all have the command of MySQL in a Single picture?

Here’s the picture. Check out my blog for more cool stuffs on programming and we also cheat sheets of Python, C and C++, Java, Linux.

Like and Share the blog with your family and friends.


Maria Irudaya Regilan J


5 book recommendations by Mark Zuckerberg for every entrepreneur

Article By, Sanjana Ray

Zuckerberg, 32, holds claim as one of the youngest billionaires across the world and has always been a voracious reader, despite his daily chock-a-block itinerary.

Run Commands Every Windows User Should Know

Article by, Vicky Singh Rao

There are several ways to efficiently access the files, folders, and programs in Windows operating system. We can create shortcuts, pin programs to the taskbar, Start menu shortcuts etc. but we can’t do it for all programs in many cases. However, the Windows Run Command box is one of the most efficient ways of accessing system programs, folders, and settings.

How to open Windows Run command box?

You need to press Win+R (Hold Windows button then Press R)

Important Run Commands Every Windows User Should Know


This is the fastest way to clear the temporary files from your computer. It can save a lot of space which was being wasted by temporary files.


This command will open the windows DOS command prompt. Windows command prompt is very useful for performing many tasks which are not possible using graphical user interface.


Windows Run Command - MSconfig-compressed
Windows System Configuration

This command will open Windows System Configuration where you can edit different things like the boot options, startup options, services, etc.


Windows Run Command - sysdm cpl-compressed
System Properties window

This command will open the System Properties window, Where you can change the system protection and performance related many settings


Powershell is very similar the command prompt. Just type this command in the Run dialog box, and you will have your PowerShell opened without administrator privileges.


Windows Run Command - perfmon msc-compressed
Windows System Performance monitor

This command can be used to monitor the performance of your computer. There are plenty of options for monitoring the system performance


Regedit Run command is used to open the Windows Registry. It is a hierarchical database that hosts all the configurations and settings of Windows operating system, it’s users and the installed software.

\ (Backslash)

This is one of the lesser known Run commands. Just enter the backslash into the Run dialog box and it will open up the C drive. It is one of the quickest ways to access the C drive.

. (Dot)

This is yet another lesser known Run command. When executed, it opens the current user’s home folder which hosts all the other local folders like the Downloads, Documents, Desktop, Pictures, etc.

.. (Double Dots)

When you execute these two dots in the Run dialog box, it will open up the Users folder which is located directly on the C drive.


This command will open the control panel. Control panel is used for managing all the system settings and programs


Windows Run Command - hdwwiz-
Windows Device Manager

This command is used to open the Device Manager in Windows. You can manage all the device connected internally or externally to your PC.


The quickest way to open notepad in Windows. Just type this command in Run Box and hit enter.


This command will open On-Screen Keyboard on your display monitor. You can easily touch and type or use your mouse for typing.


This command will open task manager where you can manage all the processes and programs running on Windows Operating system.
Also take a look at some of the other topics like downloading you tube videos without softwareDownload A Website For OfflineTricks on Internet and also some other interesting areas in your favourite programming languages. Take a look at my blog.
Maria Irudaya Regilan J

Sundar Pichai’s ‘Cockroach Theory’

Sundar Pichai continues to make global news after becoming Google’s CEO. Stories about his past, schooling and college days are viral. Well at least in India they are. Here’s another story, or rather a speech by Sundar Pichai, that is being massively shared for the past few days. It’s a speech about the ‘cockroach theory’ for self development. Here’s how the theory goes:

“At a restaurant, a cockroach suddenly flew from somewhere and sat on a lady.

She started screaming out of fear.

With a panic stricken face and trembling voice, she started jumping, with both her hands desperately trying to get rid of the cockroach.

Her reaction was contagious, as everyone in her group also got panicky.

The lady finally managed to push the cockroach away but …it landed on another lady in the group.

Now, it was the turn of the other lady in the group to continue the drama.

The waiter rushed forward to their rescue.

In the relay of throwing, the cockroach next fell upon the waiter.

The waiter stood firm, composed himself and observed the behavior of the cockroach on his shirt.

When he was confident enough, he grabbed it with his fingers and threw it out of the restaurant.

Sipping my coffee and watching the amusement, the antenna of my mind picked up a few thoughts and started wondering, was the cockroach

responsible for their histrionic behavior?

If so, then why was the waiter not disturbed?

He handled it near to perfection, without any chaos.

It is not the cockroach, but the inability of the ladies to handle the disturbance caused by the cockroach that disturbed the ladies.

I realized that, it is not the shouting of my father or my boss or my wife that disturbs me, but it’s my inability to handle the disturbances caused by their shouting that disturbs me.

It’s not the traffic jams on the road that disturbs me, but my inability to handle the disturbance caused by the traffic jam that disturbs me.

More than the problem, it’s my reaction to the problem that creates chaos in my life.

Lessons learnt from the story:

I understood, I should not react in life.

I should always respond.

The women reacted, whereas the waiter responded.

Reactions are always instinctive, whereas responses are always well thought of, just and right to save a situation from going out of hands, to avoid cracks in relationship, to avoid taking decisions in anger, anxiety, stress or hurry.

A beautiful way to understand…………LIFE.”

–         Sundar Pichai

After reading this, I am going to post my own bug story soon. Stay connected with my blog and also check out some cool stuffs in my blog. Know about Dennis Ritchie too.


Maria Irudaya Regilan J

How To Download A Website For Offline

Author, Vijay Prabhu

Our life is now centered around Internet and data connection. Without the Internet connection, we can not use our smartphones or laptops to their optimum potential. This is true when sometimes we need to access very important web pages but can’t due to Internet issues. It is for such kind of situations we are sharing a new and useful trick so that you can access websites even when you don’t have Internet access. The trick involves downloading the full website data and can browse the website at your own sweet time.

#1 Using HTTrack

HTTrack allows you to download any website for offline use and is very easy to use.  Follow the below steps to use HTTrack to download any website and browse it at your own sweet time.

Step 1. Download and install the software HTTrack from here.

Step 2. Launch the software, and it will ask you to enter the project name, project category and the default path to save the websites you download.How To Download A Complete Website To Browse Offline Without Internet

Step 3. Enter the relevant details and just click on next, Now in the text box you have to enter the URL of the site which you want to download, just paste the complete URL of the site and click on next. We are using Wikipedia as an example.How To Download A Complete Website To Browse Offline Without Internet

Step 4. HTTrack will now download the entire Wikipedia website for your offline browsing. The download process can take time, based on your internet speed and size of the website you are downloading. In our case, Wikipedia is huge so it took some time.How To Download A Complete Website To Browse Offline Without Internet

Now after download process is complete, just browse to the saved path, and there you will find your website file  that you can now browse at your own time without worrying about Internet connection.

#2 Using GetLeft

Getleft is another tool which allows you to download websites and browse them later. Like HTTrack it downloads complete website according to the options set by the user. Getleft also has a very simple UI which any noob can also use. Follow the process below to use Getleft.

Step 1. Download Getleft and open the software, press CTRL+U which will ask you to enter the URL and directory.

How To Download A Complete Website To Browse Offline Without Internet

Step 2. Now you will be asked to select the files that you want to download.

How To Download A Complete Website To Browse Offline Without Internet

Step 3. Now wait for few minutes until the files being pulled to your system.

How To Download A Complete Website To Browse Offline Without Internet

That’s it now you can browse your saved website in offline mode.

How To Download A Complete Website To Browse Offline Without Internet

#3 Using Cyotek

Cyotek WebCopy is another free tool that lets you a full or partial website locally for offline browsing. WebCopy will scan the specified website and download it’s content onto your hard disk. Links to resources such as stylesheets, images, and other pages in the website will automatically be remapped to match the local path. Using its extensive configuration, you can define which part of a website will be copied and how.

Download and install the App using the hyperlink above. Open the App and hit the “F5” Key. In the window given below enter the name of the website and the destination folder.

How To Download A Complete Website To Browse Offline Without Internet

Now you have to wait until the download process finishes.

How To Download A Complete Website To Browse Offline Without Internet

Once downloaded, you can open the file in your browser and access your saved website.

#4 Offline Downloader

Like above tools, Offline Downloader is also an offline website browsing tool but with a difference. It downloads and shows websites exactly the way you want them, including or excluding any parts you need or don’t need (such as directory, domain and file names, types of files, their size or any other properties).

How To Download A Complete Website To Browse Offline Without Internet

You just need to download and install the software offline downloader from here. Open the software and enter the URL as shown on the image and then select the file type you need to download and hit the download button. Enjoy the downloaded file at your own time and leisure.

#5 Web2Disk

How To Download A Complete Website To Browse Offline Without Internet

Web2Disk’s powerful engine allows it to modify websites as they’re downloaded so that all the links work directly from your hard drive. You’ll be able to browse the site as if it were still online. However, the main feature of Web2Disk is its ability to show you downloaded websites in any browser you choose.

You just need to enter the URL in ‘Root URL’ and then browse the location to save the entire website and then hit the ‘Go’ button.

If you have unstable Internet connection or slow data connection, use any of the five tools given above and enjoy your favourite websites even when you dont have Internet access.

Check out my blog for other cool stuffs and some other online tricks like downloading youtube videos without any software.


Maria Irudaya Regilan J