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.
|1||Altab shaikh||altab||123 shivaji chouk||Navi Mumbai||1234||India|
|2||Seema yuvin||seema||Obere Str. 57||Mumbai||1526||India|
|3||Anna jen||anna||Mataderos 2312||Pune||2312||Mexico|
|4||Ela dan||ela dan||120 Hanover Sq.||hyderabad||12312||USA|
To selects all the records in the “Customers” table:
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
|Commands||Use of Commands|
|UPDATE||Updates data in a database|
|DELETE||Deletes data from a database|
|INSERT INTO||Inserts into a database new data|
|CREATE DATABASE||Creates a new database|
|ALTER DATABASE||Modifies a database|
|CREATE TABLE||Creates a new table|
|ALTER TABLE||Modifies a table|
|DROP TABLE||Deletes a table|
|CREATE INDEX||Creates an index (search key)|
|DROP INDEX||Deletes 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