Tutorial MySQL - Introduction
MySQL is an open source database server that
look like most popular. MySQL generally use php script to make a dynamic and
powerful application server.
Interested? Just read and we start our first mySQL tutorial. Happy learn,
let’s go...
Database, What is it?
A database is a structure that generally put in two categories: A flat and
relational database. Relational database more like because more sense than
flat database. So, mySQL is a relational database.
In database which has rational structure. There are tables that deposited
data. Every table consists from column and row. A column definite what kind
of information will deposited. you need special column for every kind of
information you will deposited (example age, high, weight, address)
If column definition what kind of information will deposited, a row is
actual data deposited. Every row from column is input from that table and
containing value for every column of that table. (Example input is bambang:
age 40, 65 kg, and 160 cm).
If this database explanation confusing you, don’t give it up, we will
explain and show few table example in the next tutorial.
Why using database?
Database will be useful when you
need to deposited information which category logic. Example, lets said you
want to deposited information about all employees in a company. With
database, you can grouping many thing in business be several table. Table
example can be sales, employee, .receivable accounts, execution, etc.
SQL?
Sql (read “ess-que-el”) is short
term from structured query language. SQL used to communication with a
database.
Appropriate with ANSI, SQL is standard language for management system
relational database. SQL statement used to do duty like up date database, or
take data from database.
Several relational database which using popular SQL is mySQL, oracle,sybase,
microsoft SQL server, access, ingres, etc.
Although most database system using SQL, but most of them also has special
extension that can use only in their own system. even then, SQL standard
command like " select ", " insert ", " update " , " delete ", " created ",
and " drop " can use in nearly all the thing need to do to a database.
This tutorial will introduce you at basic used from that command. You can
practice with installing mySQL or other database in your computer.
Written by Prothelord.com |