The great thing about everything you do in MySQL is that the "code" is very easy for humans to read, as opposed to harder programming languages like C or C++. The very few special characters and symbols are required to create a MySQL query.
In which strategies to Learn MySQL
The MySQL language is not as complicated as most programming languages, it's the best way to learn is with direct examples. In mysql this tutorial focuses on the combination of MySQL and PHP, most of the examples are ready for you to copy, paste, and run on your web server.
What is the meaning of CAPITALIZATION in MySQL Queries
In MySQL there are many keywords,and a good programming habit when using ANY of these words is to capitalize them. And This helps draw them out from the rest of the code and makes them much easier to read. Below is an example of a MySQL query written in PHP that retrieves all the data from a MySQL table named "Hello".
$result = mysql_query("SELECT * FROM Hello")
The code is valid in PHP , but it also containing into a valid MySQL. The text that appears between the quotations "SELECT * FROM Hello", is the MySQL code.
We probably can tell "SELECT" and "FROM" are the MySQL keywords using in this query. And it's capitalizing them allows you to tell from a quick glance that this query selects data from a table.
we can view a complete list of MySQL keywords at List of Reserved MySQL Words, but don't worry about memorizing them. You could program relentlessly in MySQL for years without ever using all of the MySQL keywords.
Learn at Your Own Pace
While learning MySQL, it is best to take it one lesson at a time and stop when you feel frustrated. Do not worry if it takes you more than a week to finish this tutorial. If you take the time to progress slowly, you will be much more well-informed about the MySQL database system than if you rushed through it in one sitting.