Learn MySQL

MySQL is an open source database server that seems most popular existence. MySQL is generally used in conjunction with PHP scripts to create an application server that is dynamic and powerful.
Database, is?A database is a structure that is generally categorized in 2 ways: A flat database and a relational database. Relational database is preferred because it makes more sense than a flat database. Well, MySQL is a relational database.In a relational database structure. There are tables that store data. Each table consists of columns and rows. A column defines what type of information will be stored. You need a special column for each type of information you want to keep (such as age, height, weight, address)If the column defines what type of information will be stored, then a row is the actual data stored. Each row of the table is input from the table and contains the values for each column of the table. (Inputs is Bambang example: age of 40 years, 65 kg and 160cm). If discussion of this database is confusing to you, do not despair, we will discuss and demonstrate some examples of tables in the next tutorial.

Why use a Database?
The database will be very useful when you need to store information that is categorized logically. For example, let's say you want to store information about all employees in a company. With the database, you can group together things in business into several tables. Example table could have a table sales, employees, accounts receivable, performance, etc..SQL?
SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. In accordance with ANSI, SQL is a standard language for relational database management system. SQL statements used to perform tasks such as updating a database, or retrieve data from a database. Some relational databases using SQL and quite popular are: MySQL, Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, but most of them also have a special extension that can only be used in each system. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to do almost anything that needs to be done against a database. This tutorial will introduce you to basic use of the command. You can practice with installing MySQL or other database on your computer.
Ok, next we'll get to know the terms that are very important in the Introduction SQL Query.In previous MySQL tutorial, you learned about databases dah right? Well in the world of daily practice you are rarely going tuh make database theory. You will be a lot to do with the name query. Remember, the Query is your main weapon in the daily working with databases. If you want to learn MySQL, Query tuh learn first. Ready to learn Query? Keep reading guys ...
Query is the term used to express a variety of SQL commands. Each command to do some things against the database. For example, the CREATE will create tables and databases, while the SELECT will select the rows that you've inserted in the database. We will explore in detail later, but for the initial stage, we will try to review some of the structure of queries.
Query Construction begins with one of the following commands:

    * ADD
    * DROP
    * CREATE
    * INSERT
    * SELECT
    * UPDATE
    * REPLACE
    * DELETE
Query has a lot of leeway in writing. Enter a space and not so diperhatiken in writing. This means that if by chance any spaces mostly write, no problem. Gitu.Nah, Now we already understand that the query was preceded by the command. What should you write after that depending on what commands you use.

Or way of writing query syntax is loose, it means you are free to type enter anywhere without disturbing the code written. Some commands require curly braces ({}), like insert commands below. Writing these brackets will be discussed also in the discussion of the function. Just make sure to end each command that you create with a semicolon (;).
To give an idea for you I'll write some sample queries and note the simplicity yes, let the spirit!
 SQL Code:

  SELECT * FROM table_name;
The above code selects all rows and columns of the table table_name and display it on us. Here are a few more queries which will very often you wear with the passing of our tutorial.