MySQL Introduction

MySQL Introduction

MySQL is one of the popular Database Management System. The full form of MySQL is Structured Query Language. The data are stored in a table form in MySQL. Every column has a specific data type that you can specify during the creation of the table.

You can perform the opertions such are –

• insert – to add a new row to the table.
• update – to edit the data in a row of a table.
• delete – to delete a row of table.
• select – to select a particular row of a table.

Features of MySQL

• MySQL is an open-source relational database management system.
• MySQL compiles on a number of platforms.
• MySQL is free to download and use.
• MySQL support to both large and small applications.

How MySQL Works

MySQL is a Structured Query Language Which is works on the queries. If you want to perform any operation in the MySQL you have to write a query in a specific format or proper sequence of words.

For example if you want to select rows from a table than you have to use the SELECT Query

 SELECT * FROM tablename; 

Here the above query is used to select all the rows of a table are selected. but have to specify the name of the table at the place of tablename in the above query.