Inroduction to MYSQL [Lesson 1]

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.

MYSQL Syntax

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 .

Advertisements

One Response to Inroduction to MYSQL [Lesson 1]

  1. jwanleo says:

    Hello
    thank you joker400 for this nice introduction.

    I know some about MySQL , and I will improve it with your posts .
    continue ….. I’m following u.

    My Regrades

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: