MySQL Intorduction

MySQL is a popular, open-source, relational database that you can use to build all sorts of web databases — from simple ones, cataloging some basic information like book recommendations to more complex data warehouses, hosting hundreds of thousands of records. Learning MySQL is a great next step for those who already know PHP or Perl. In this case, you can create websites that interact with a MySQL database in real-time and display searchable and categorized records to users.

Similar to other programming languages like PHP, JavaScript, HTML, and jQuery, MySQL relies on commenting to execute any commands. You can write two types of comments in MySQL:

Single-Line Comments:

These start with “–”. Any text that goes after the dash and till the end of the line will not be taken into account by the compiler.

Example:
-Update all :
SELECT * FROM Employees;

 Multi-Line Comments:

These start with /* and end with */. Again, any text that is beyond the slashes lines will be ignored by the compiler.

Example:
/*Select all the columns
of all the records
in the Movies table:*/
SELECT * FROM Movies;

Keeping this in mind, let’s get started with actual coding.

 

Do you know?
Written By
Cinque Terre
GeeksCoder

March 08 ,2021