MySQL Features

I have decided in adding some more information about MySQL instead of its plain history. Lets have a look at MySQL features.

As its first development, creating stored procedure that are some features belong and able to run in Oracle, its not possible, yet after the fifth official release, MySQL 5.1 have equipped with these features. With these features calling a procedure will made the traffic in server would be more lesser.

Not just stored procedure, there are another features that owned by MySQL which made database administrator and programmer turn their head migrating to MySQL.

Portability, would be its reliable features. MySQL able to work in various number of Operating system such as Windows, Linux, Unix, Mac OS, Solaris, Unix, Amiga, HP-UX, Symbian.

“Limited” Open Source software. Yes before MySQL license is under GNU GPL or free open source software, yet since its being owned by SUN, later became Oracle. Some features are being limited, and these features are open for some user whom deciding in renew or register their license.

Despite its limitation, yet basic features is okay for web development, since ordinary or basic development of website doesn’t require some complicated features.

Some other feature of MySQL which being counted as one of reliable open source software are Multi-user features, performance tuning, security, and etc.

Multi-user meaning user able to access the server database in the same time without having any serious conflict. While performance tuning meaning that MySQL able to handle more query much more faster then previous software release.

As for security, level of subnet mask, hostname, and user privilege with encrypted password would be serious features offered by MySQL.

While in command and function creation, complex column type and similar SQL command which being used in MSSQL and Oracle would be another benefit of MySQL, so its easier for programmer to understand it more faster and easily.

There might be something you should know about MySQL, unlike other database application, each of MySQL command should be ended with semicolon (;), or it will generate warning and error.

Case sensitive rules in command writing only applied in database object naming in Unix and Linux OS only, as for other the rules are not required.

© Software and OS