MySQL introduction

Refer  Command line interface & GUI interface

You can directly download MySQL from this link .

But , here , I am using WAMP Server to write code in MySQL.
Check this link  WAMP Server . 

Select MySQL from the pop-up menu , while clicking WAMP SERVER .
Then we can see , the command prompt like this , where we can type SQL Queries. 

Refer the database and tables created in SQL , by clicking this link .

Starting SQL Commands 

Now , we are going to some quick reference of SQL commands .I think , it will be very helpful for you , rather than going through the whole section. Click the given link to go there . 

Quick reference of SQL commands .

=====================================================================

Back to SQL , WAMP Server and HOME

Command line interface & GUI interface

AS you might know , SQL is a standard language for accessing databases.

Command line vs. GUI

Refer these ,

SQL-create Database & Table  to see what is GUI interface and , refer JAVA Console application to know what is a Command Prompt.

From the above link , you can understand that ,unlike a command line , GUI Operating Systems are much easier for end-users to learn and use because commands do not need to be known or memorized. Because of their ease of use, GUI Operating Systems have become the dominant operating system used by end-users today.

A command line interface requires unique commands, this interface is often more difficult to learn because of the need to memorize dozens of different commands. However, a command line operating system can be a very valuable resource and should not be ignored. For example, users who have Microsoft Windows may find trivial tasks such as renaming 100+ files in a folder a very difficult task; however, this is something that can be done in a matter of seconds through a simple command at the command line.

Now , I am going to introduce the SQL commands (Here , I am using the WAMP Server to write SQL commands.

Check this link  WAMP Server  to write SQLcodes , in Command prompt. 

Duble click on wamp server , after referring this link . As per the description given in  the link ,click  MySQL , we can see a window , where we can type SQL Commands there..

Back to SQL , Wamp Server and HOME