A Brief Overview On MySQL

A Brief Overview On MySQL

MySQL is an open-source relational database management system (RDBMS)

The name MySQL is a combination of “My”, the name of co-founder Michael Widenius’ daughter Where “SQL”. The abbreviation for Structured Query Language.


The MySQL development projects have its source code available under the terms of the GNU General Public License. As well as under a variety of proprietary agreements SQL was created, owned and sponsored by a single for-profit firm. The Swedish company MySQL AB, which was a software company, founded in 1995. Acquired by Sun Microsystems in 2008. Later in 2010 Sun was acquired by Oracle Corporation.Since 2010 its owned by Oracle Corporation.

SQL is a central component of the LAMP open-source web application software stack and other “AMP” stacks (where LAMP is an acronym for Linux, Apache, MySQL, Perl/PHP/Python). Applications that use the SQL database include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, and Drupal. SQL is also used in many high-profile, large-scale websites, including Google, Facebook, Twitter, Flickr, YouTube and by some others too.

MySQL is written in C and C++. Its SQL parser is written in yacc, but it uses a home-brewed lexical analyser. It can work on many systems platforms, including AIX, BSDi, FreeBSD, HP-UX, eComStation, i5/OS, IRIX, Linux, macOS, Microsoft Windows, NetBSD, Novell NetWare, OpenBSD, OpenSolaris, OS/2 Warp, QNX, Oracle Solaris, Symbian, SunOS, SCO OpenServer, SCO UnixWare, Sanos and Tru64.The SQLs server software itself and the client libraries use dual-licensing distribution. They are offered under GPL version 2, June 2000 (Extended with a FLOSS License Exception in 2009) and to use a proprietary license.

Many programming languages having language-specific APIs include libraries for accessing SQL databases. Which include SQL Connector/Net for integration with Microsoft’s Visual Studio  and the JDBC driver for Java. ODBC interface also called My SQL Connector which allows ODBC for additional programming languages supporting its interface to communicate with a SQL database, like ASP or ColdFusion. The HTSQL – URL-based query method also ships with a MySQL adapter, allowing direct interaction between a MySQL database and any web client via structured URLs.

SQL own positive reviews, by the reviewers as it performs extremely well in the average case and have developer interfaces. Also have the documentation  its fast, stable and true multi-user, multi-threaded sql database server.




Best books to learn

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *