Advantages And Disadvantages MySQL

indeed there are many applications in addition to the MySQL database management, but why in this book was chosen MySQL as the database management application as a supplement in learning web programming with PHP processing implemented on the database.some of the exact reasons are the following :1. Portability. MySQL can run stable on a variety of operating systems Windows, Linux, FreeBSD, Mac Os X Server, Solaris, Amiga, and many more.
2. Software is open source. MySQL is distributed as open source software, licensed under the GPL so it can be used free of charge
3. Supports Multi-user. MySQL can be used by multiple users at the same time without experiencing any problems or conflicts.
4. Performance Tuning: MySQL has an amazing speed in dealing with simple queries, in other words be able to process more SQL per unit time
5. Various types of data. MySQL has a variety of data types that are very rich, such as signed / unsigned integer, float, double, char, text, date, timestamp, and others.
6. Commands and Functions MySQL:MySQL has full operators and functions that support the SELECT command in the command where the funds(Query)
7. Is safe. MySQL has several layers of security such as the level subnetmask, host name, and access permissions a user with a detailed system permissions and passwords encrypted
8. Scalability and restrictions.MySQL database capable of handling large scale, with a number of records more than 50 million 60 thousand tables as well as 5 billion baris.selain it limits the index that can fit up to 32 indexes on each table.
9. connectivity. MySQL DAPT to connect with clients using TCP / IP, Unix socket (unix), or Named Pipes (NT).
10. Localization. MySQL can detect the error message on the client by using more than twenty languages. however, the Indonesian language has not been included therein.
11. Interface. MySQL has an interface to a variety of applications and programming languages ​​by using the function API (Application Programming Interface).
12. Tool. MySQL comes with a variety of equipment (tools) that can be used for database administration, and any existing equipment pa online manual included.
13. Table structure. MySQL has a table structure that is more flexible in handling change, compared to other databases like PostgreSQL or Oracle.
14. Free of charge. is perfect for anyone who wants to learn as well as for the expert level because complex software with a myriad of advantages of this is free.
So much of the information before me, may be useful.

What is Mysql??

MySQL previous term may sound a bit strange, especially if you are the first time to know him, but for a databasi administrator, MySQL is one of the daily diet. Here we will learn more about MySQL problems.

understanding MySQL
   MySQL is one of the software database management system (database) or oftenreferred to as SQL DBMS (Database Management System) is different from conventionaldatabases such as *. dat, *. dbf, *. mdb, mysql bag 2 has the advantages of naturemultithreaded, and multi-user and network support systems, MySQL is freely distributableunder the GNU General Public license (GPL), namunada also a commercial version forcertain circles who want it. What is a Database? before we discuss more about MySQL, it helps us learn things about the database. Database or database is a collection of information or data in a systematic way so that it can be checked by a computer programto obtain information from the database.

   in a database typically consists of tables in a table where there is structural information that can be read systematically. The tables in a database are usually interrelated and have a relationship with one another.

Table, Field, Record
   when struggling with the database then inevitably we will use the term a lot of the Table,Field, Record. so let us understand at a glance notions isitlah problems mentioned above.
The table is a set of Record and Field form one entity.

Record is a row of a table.
A field is a column of a table.
If plotted on a diagram the relationship between the Database, Table, Field and Recordare as follows:




in the figure above shows that a database can consist of a set of records (rows) and fields(columns).

So much may be used to post about MySQL this time it may be useful.