MySQL History to Basics

MySQL History to Basics

One of the open-source relational database management system is MySQL, name of the mySQL is originated by the combination of name of the founders daughter with My “Monty Widenius’s daughter: My”, It was first released in 1995

From the relational database programmers extract the data using functions create, modify and extract data also control user access to the database.

MySQL is works under the general public liecense(GNU), first it was owned by MySQL AB, which later brought by Sun Microsystems which now known as oracle corporation, MySQL allows users to interact directly with a MySQL database using SQL due to its has stand-alone clients availability. However, MySQL is often practiced with other programs to execute applications that need relational database capability.

Its written in c and C++ language, MySQL is very fast, reliable, scalable, and easy to use

Big companies like Facebook, Airbnb, Twitter, Booking.com, GitHub, Uber, YouTube, etc. event the Content Management organizations WordPress, Drupal, Joomla!, Contao, etc also big player in the industry using MySQL to manage the database.

When we talk about mySQL, SQL also comes in our mind. However, MySQL is a database that stores the existing data in a database in an organized manner, and SQL is a query language. In contrast, MySQL is a relational database that practices SQL to query a database. You can use SQL to update, access, and manipulate the data stored in a database. 

It’s a organized way of storing data, so that we can easily access as well as manage. Database is to organize data into rows and columns in the table

Before starting to learn about MySQL you need to install MySQL in your system, if you are using windows 10, click  here which will help you how to install mysql in windows 10.

Now you all must have install MySQL in your windows 10 system. Lets start with some some basic practical knowledge of MySQL command.

In the command SQL keywords we will use are  all case sensitive, select is keyword you can write it SELECT or select it will gives the same result

Some commands needed semicolon to execute its not only the standard way of separating each SQL statement in the database. Else more than one sql statement will execute at the same time.

CustomerIDCustomerNameContactNameAddressCityPostalCodeCountry
1Altab shaikhaltab123 shivaji choukNavi Mumbai1234India
2Seema yuvinseemaObere Str. 57Mumbai1526India
3Anna jenannaMataderos 2312Pune2312Mexico
4Ela danela dan120 Hanover Sq.hyderabad12312USA

To selects all the records in the “Customers” table:

Command :

SELECT * FROM Customers;

This will return all the data of the data as it is.

Alike SELECT command below are some more commands we can use for the basic operations

CommandsUse of Commands
UPDATEUpdates data in a database
DELETEDeletes data from a database
INSERT INTOInserts into a database new data
CREATE DATABASECreates a new database
ALTER DATABASEModifies a database
CREATE TABLECreates a new table
ALTER TABLEModifies a table
DROP TABLEDeletes a table
CREATE INDEXCreates an index (search key)
DROP INDEXDeletes an index

Conclusion: MySQL is very interesting thing to learn in the programming world you will definitely enjoy using and playing with this command.

Read More blogs,

>> AWS Interview Questions and Answers

>> Pearson VUE Microsoft