Understanding MySQL
MySQL is the database server
software or call it Smart Database. This database is becoming increasingly
popular. By using this database, data more secure and efficient. This database
is also widely used in web database so that the integrated data between desktop
database with a web database. To use the MySQL database must first install it
to your computer.
MySQL Privileges
As a database server with the
concept of a modern database, MySQL has a privilege. MySQL has several features
as follows:
1.
Portability
MySQL database to function with stable without constraint, means the
force on various operating systems like Windows, Linux, FreeBSD, Mac OS X
Server, Solaris, Amiga, HP-Unix, and others.
2.
Open Source
MySQL is a database of open source (free), under the GPL license so it
can obtain and use it freely without paying any sepersen.
3.
Multiuser
MySQL is a database that can be used to handle multiple users at the same
time without experiencing problems. And allows a database server MySQL client
simultaneously accessible anyway.
4.
Performace Tuning
MySQL has a pretty good speed in dealing with simple queries, and capable
of processing more SQL per unit time.
5.
Column Type
MySQL database is supported with a very complex data types, such as
signed / unsigned integer, float, double, char, varchar, text, BLOB, data,
time, datetime, timestamp, year, set and enum.
6.
Command and Functions
MySQL server has full operators and functions that support the command
SELECT and WHERE in the query.
7.
Security
Security system in MySQL has several layers of security such as levels
subnetmask, host name, and permit access to the user with a detailed system of
licensing and encrypted passwords.
8.
Scalability and Limits
MySQL has the ability to handle large-scale databases, with the number of
records more than 50 million and 60 thousand tables and rows 5 billion.
Moreover, it can accommodate up to 32 index index on each table.
9.
Connectivity
The ability to connect to the MySQL client using TCP / IP, Unix socket
(Unix), or Named Pipes (NT).
10.
Localization
The ability to detect the error (error code) on the client using more
than twenty languages.
11.
Interface
MySQL has an interface to a variety of applications and programming
languages using the function API (Application
Programming Interface).
12.
Clients and Tools
MySQL database has various tools that can be used for database
administration.
13.
Table Structure
MySQL
has a table structure is good enough and flexible enough, for example when
dealing with alter table.
Link Download :
Link Download :
Mysql-essential-v.5.0.45-win32
http://www.mediafire.com/?1otyifmzyig#1
http://www.mediafire.com/?1otyifmzyig#1