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.
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.
-Update all : SELECT * FROM Employees;
These start with /* and end with */. Again, any text that is beyond the slashes lines will be ignored by the compiler.
/*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.