Got it

The Series of MySQL -1- Basic of MySQL - EP 01_03

Latest reply: May 22, 2022 12:24:31 835 25 20 0 0

The Series of MySQL -1- Basic of MySQL - EP 01_03


HI Hi, Greetings!  i_f47.gif 

Happy December i_f25.gif


Hi Everyone,


Today, I would like to share with you an article about the first episode of Series of MySQL (Basic of MySQL), and the content is given below.


a.    Version of MySQL

b.   Differences

                                       i.    PostgreSQL vs MySQL

                                      ii.    MySQL vs Oracle


a.    Version of MySQL:

Versioning is the process of assigning distinct version names or numbers to a group of software programs when they are created and distributed. The term "version 1.0" is widely used to refer to a software or program's initial release. There is no industry standard guideline that governs how version numbers are formatted. As a result, each corporation has its own system for naming software versions. When new features in software and programs are added, bugs are fixed, and security vulnerabilities are plugged in, the version number is changed to reflect these advancements.


The most recent version of MySQL support is version v5.8. Many important modifications have been made, including the addition and removal of new features, the correction of bugs and security issues, and so on. This version provides the MySQL 8.0 to MySQL 8.0.21 release history. It will be available starting in April 2018 and will be supported through April 2026.


When installing MySQL on your PC, you must select the version and distribution format you want to use. MySQL is available in two versions, the first of which is a development release and the second of which is a General Availability (GA) release. The development release contains the most recent feature and should not be used in production. The GA release, often known as the production or stable release, is primarily used for production. As a result, the most recent General Availability release must be chosen.


Version Name

Released Date

End of Support


MySQL 5.1

November   2008

December   2013

Releases   of MySQL between 5.0 to 5.1.73

MySQL 5.5

December   2010

December   2018

Releases   of MySQL between 5.5 to 5.5.62

MySQL 5.6

February   2013

February   2021

Releases   of MySQL between 5.6 to 5.5.45

MySQL 5.7

October   2015

October   2023

Releases   of MySQL between 5.7 to 5.6.27

MySQL 8.0

April 2018

April   2026

Releases   of MySQL between 8.0 to 8.0.21


b.   Differences

                                       i.    PostgreSQL vs MySQL






PostgreSQL is an open-source, cross-platform,   and object-relational database management system (ORDBMS) built in the computer science department, University of California.

It is an open-source, cross-platform relational database management system built by Swedish Company MYSQL AB and currently supported by Oracle.

Known as

PostgreSQL is a more densely featured database system. It is described as the most advanced open-source database version of Oracle in the world.

MySQL is known for its fast speed, but it is less featured than PostgreSQL. It is the most popular database among the organization.


It was released as Postgre95 in May 1995.

It was released in 1995.


It is licensed under the MIT style.

It is licensed under the GNU (General Public   License).


PostgreSQL is popular among the developers who come from the Oracle or SQL Server background.

MySQL is popular among developers because of its fast speed and ease of use.

GUI Tool

It provides PgAdmin GUI.

It provides MySQL Workbench GUI.

Storage Engine

PostgreSQL is a unified database server having a single storage engine.

MySQL has a multi-layer structure having a   set of storage engines. For example, InnoDB, MyISAM.

ACID   Compliance

It has the complete support of   ACID-compliant.

Only some versions are ACID-compliant.

Main Focus

PostgreSQL is developed with a focus on features and standards.

MySQL is developed with a focus on speed.


PostgreSQL is generally used on large and complex operations. It is more reliable for them.

MySQL is generally used on simple operations.


It has Native SSL support.

It has TLS support.


PostgreSQL provides reliability, data integrity, and developers-friendly features.

MySQL is generally used with PHP to deal with web pages and optimize simple queries.

Temporary   Table

It does not have a TEMP or TEMPORARY keyword   in the DROP TABLE statement.

It has a TEMP or TEMPORARY keyword in the   DROP TABLE statement to remove the temporary table.

Table   Inheritance

It supports.

It does not Support.


Asynchronous, Cascade, and Synchronous.

Asynchronous, Synchronous, and   Semi-synchronous.

Task Scheduler

It has a pgAgent task scheduler.

It has a Scheduled event.

Connection   Scalability

Here, every time a connection is created, it is an OS process.

Here, every time a connection is created, it is an OS thread.

Community   Support

It has strong and active community support of developers who continually improve the existing features with access to free resources.

It has broad community support of developers who always maintain existing features with new features.


                                      ii.    MySQL vs Oracle:






It was released in 1995.

It was released in 1980.


It is free and open-source. It is licensed under the GNU.

It is licensed for commercial purposes, but it provides the express edition for free. The express edition is recommended for students only.


MySQL database is used for small and big businesses.

Oracle database is used for very large-scale deployments.

Data Partitioning

It does not support data partitioning.

It supports data partitioning.


It requires a username, password, and host to access the database.

It requires a username, password, and profile validation to access the database.

System Type

It only works with the static system.

It can work with both static and dynamic systems.

Null Value

MySQL supports the null value.

Oracle does not support the null value.


MySQL support only two characters that are   CHAR and VARCHAR.

Oracle supports four different characters that are CHAR, VARCHAR2, NCHAR, and NVARCHAR2.

Backup   Mechanism

It offers only two backup mechanisms that are mysqlhotcopy and mysqldump.

It offers many backup mechanisms that are backup, hot backup, import, export, etc.

XML Support

It does not support XML.

It supports XML.

Storage   Features

It contains only a few storage features like tablespace, synonym, packages, and many others.

It supports many storage features that are tablespace, synonym, packages, etc.

Locking   facility

MySQL has only a table locking facility.

Oracle has table locking as well as a row locking facility.

Language   support

MySQL support only SQL language.

Oracle supports both SQL and PL/SQL   languages.

Operating System Support

It   supports the following Operating systems:

Windows,   Mac OS X, Linux, UNIX

It   supports the following Operating systems:

Windows,   Mac OS X, Linux, UNIX


You are welcome to like and leave feedback in the comment area. 



EP 01_01:

The Series of MySQL -1- Basic of MySQL - EP 01_01

EP 01_02:

EP 01_04:

EP 01_05:

The Series of MySQL -1- Basic of MySQL - EP 01_05





M M Zaheer Hussain

Stay Safe!


The post is synchronized to: Author groupzaheernew's Author Collection

  • x
  • convention:

Moderator Created Dec 29, 2021 16:49:59

Thanks for sharing
View more
  • x
  • convention:

MVE Author Created Dec 30, 2021 18:42:35

  • x
  • convention:

little_fish Created Jan 10, 2022 06:34:07 (0) (0)
Created Dec 31, 2021 06:02:57

The Series of MySQL -1- Basic of MySQL - EP 01_03-4572243-1
View more
  • x
  • convention:

Created Dec 31, 2021 06:04:34

Good share
View more
  • x
  • convention:

zaheernew Created Dec 31, 2021 08:56:24 (0) (0)
Created Jan 1, 2022 04:49:04

Good share
View more
  • x
  • convention:

zaheernew Created Jan 1, 2022 15:12:44 (0) (0)
Moderator Author Created Jan 2, 2022 12:02:19

Thanks for sharing
View more
  • x
  • convention:

MVE Author Created Jan 9, 2022 06:19:06

@wissal @BAZ @Unicef @user_4147187 @E.DR_91 @umaryaqub @sachandio @Malik3000 @MahMush @Abdussamed @Vlada85 @cmarban @lucian2003 @sliawatimena @hamza1 @amr_rashedy @Diego.Silva @andersoncf1 @bruno.guedes @Kashif @Lucfabrice @AymanOT @tubaboraka @DrDoom @Mahedi @Aqeel73 @Saqib123 @DienLg @Anno7 @IndianKid @Rumana @Vesper_EvenStar @Irina @AL_93 @faysalji @jason_hu @Y_T_Z @Somemeow @hemin88 @Kevin_Thomas @harisaliehsan @Irshadhussain @azkasaqib @NTan33 @hanhcao @mytruc
View more
  • x
  • convention:

Created Jan 9, 2022 06:37:11

The Series of MySQL -1- Basic of MySQL - EP 01_03-4588507-1
View more
  • x
  • convention:

Moderator Author Created Jan 11, 2022 09:34:14

Thanks for sharing
View more
  • x
  • convention:

Back to list


You need to log in to comment to the post Login | Register

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits


Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Please bind your phone number to obtain invitation bonus.
Information Protection Guide
Thanks for using Huawei Enterprise Support Community! We will help you learn how we collect, use, store and share your personal information and the rights you have in accordance with Privacy Policy and User Agreement.