MySQL Introduction


Welcome to the MySQL Tutorial at coffeendcode.com website. You will learn the MySQL here with complete examples from basic to advance.

 

This coffeendcode.com will provide the learner with a complete MySQL tutorial displayed in the easy chapter with a simple example. Here every tutorial has practical examples with Source Code and after the output of example.  

 

The MySQL name is a combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language. 

 

The MySQL is an open-source relational database management system (RDBMS) is based on Structured Query Language (SQL). It is used with various application e-commerce, logging applications, data warehousing, Social Media etc.

 

The most common use of MySQL is a database of web applications. 

 

The following are the MySQL Version Released history

 

Release General availability Latest minor version Latest release End of support
5.1 November 14, 2008 5.1.73 03/12/2013 December 2013
5.5 December 3, 2010 5.5.61 27/07/2018 December 2018
5.6 February 5, 2013 5.6.41 27/07/2018 February 2021
5.7 October 21, 2015 5.7.23 27/07/2018 October 2023
8.0 April 19, 2018 8.0.12 27/07/2018 April 2026

 


Features

 

The following are the major features of MySQL :


  • Relational Database System :  Similar to the other database MySQL is a relational database system.
  • Client/Server Architecture  :  MySQL is a client/server system in which MySQL and applications communicate
      with the server to perform the data transaction by the SQL queries.
  • Stored procedures : The MySQL supports the Stored procedures to perform the operation on data to Insert, Update, Delete, Select, Truncate etc. MySQL has supported Stored procedures since version 5.0.
  • Views : The MySQL supports the Views it is related to SQL query, we can create Views using SQL queries. MySQL has supported views since version 5.0.
  • Unicode : The MySQL supports all Unicode characters since MySQL version 4.1, including Latin-1, Latin-2, and Unicode (either in the variant UTF8 or UCS2).
  • Foreign key constraints : The MySQL supports Foreign key constraints it is related to the SQL queries which help to create a relationship among database tables.
  • ODBC Connection : MySQL supports ODBC connection between database and application to perform the data transactions.
  • Platform independence : The MySQL can be executed under a number of operating systems such as Microsoft Windows, Apple Macintosh OS X and Unix system like as Sun Solaris, Net BSD, FreeBSD, BSDI
  • Speed : The MySQL speed has been supported up by a huge number of benchmark tests so it is considered a very fast program database.
  • User interface : The MySQL supports various user interfaces
  • Replication : The MySQL supports replication of contents which means we can copy the contents of a database and can replicate on the various system.
  • Programming languages : The MySQL supports the various applications for programming such as C, Java , Python , Asp.net, C#, PHP, C++, Tcl and Perl.

In the next chapter. we will guide how to download and install the MySQL latest version on the system.


Copyright 2018, Coffeendcode.com     Disclaimer & Privacy Policy | Contact Us

Twitter Coffendcode facebook Coffendcode LinkedIn Coffendcode