Welcome this My first tutorial in MySQL i hope you find this tutorial useful…. OK lets start.
MySQL is currently the most popular open source database server in existence. On top of that, it is very commonly used in conjunction with PHP scripts to create powerful and dynamic server-side applications.
One of the greatest thing about MySQL is that the “code” is very easy for humans to read, as opposed to harder programming languages like C or C++. Very few special characters and symbols are required to create a MySQL query, and most queries uses simple English words!
How To Learn MySQL
The MySQL language is not as complicated as most programming languages, so the best way to learn is with direct examples. Because 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.
Good Programming Habit
There is a lot of keywords in MySQL and its a good programming habit to capitalize them when you are using it in your program or script .
- $query = mysql_query(“SELECT * FROM example”)
That line of code is valid PHP, but it also contains valid MySQL. The text that appears between the quotations “SELECT * FROM example”, is the MySQL code.
As you probably can tell “SELECT” and “FROM” are the MySQL keywords used in this query. Capitalizing them allows you to tell from a quick glance that this query selects data from a table.
You 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.
That is all for this tutorial, sett back and read more about MySQL database and wait for the next tutorial until that time … goodbye… see you .