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

Description

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

 

Parameter

PostgreSQL

MySQL

Definition

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.

Release

It was released as Postgre95 in May 1995.

It was released in 1995.

Licensing

It is licensed under the MIT style.

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

Popularity

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.

Used

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

MySQL is generally used on simple operations.

Security

It has Native SSL support.

It has TLS support.

Provides

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.

Replication

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:

 

Parameter

MySQL

Oracle

Release

It was released in 1995.

It was released in 1980.

Cost

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.

Scalability

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.

Security

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.

Character

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. 


Link: 


Main:



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


 

Source: 

·        https://www.w3schools.com/mySQl/default.asp

·        https://www.mysqltutorial.org/mysql-basics/


M M Zaheer Hussain

Stay Safe!

tt

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

  • x
  • convention:

Saqib123
Moderator Created Dec 29, 2021 16:49:59

Thanks for sharing
View more
  • x
  • convention:

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

  • x
  • convention:

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

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

huyvan
Created Dec 31, 2021 06:04:34

Good share
View more
  • x
  • convention:

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

Good share
View more
  • x
  • convention:

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

Thanks for sharing
View more
  • x
  • convention:

zaheernew
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:

BWGARM
Created Jan 9, 2022 06:37:11

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

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

Thanks for sharing
View more
  • x
  • convention:

12
Back to list

Comment

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

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

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
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.