Got it

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

Latest reply: Feb 27, 2022 17:04:38 747 22 16 0 0

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

 

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.    Importance of MySQL

b.   Features of MySQL

c.    Pros & Cons of MySQL

 

a.    Importance of MySQL:


·       You don't have to pay anything to use MySQL because it's an open-source database.

·       MySQL is a very powerful application that can handle a wide range of database functions normally found only in the most expensive and powerful database solutions.

·       MySQL is adaptable because it is an open-source database, and the open-source GPL license allows programmers to customize the SQL software to their own needs.

·       MySQL is faster than other databases, thus it can handle big data sets with ease.

·       MySQL works with a variety of operating systems and languages, including PHP, PERL, C, C++, JAVA, and others.

·       MySQL makes use of a standard version of the widely used SQL data language.

·       MySQL works well with PHP, the most common web development language.

·       MySQL can handle huge databases with up to 50 million rows in a table. The default file size limit for a table is 4GB, however, you can expand it to a theoretical limit of 8 million gigabytes (assuming your operating system can handle it) (TB).

 

b.   Features of MySQL:

 

·       System for Managing Relational Databases (RDBMS)

 

MySQL is a database management system that uses a relational model. The SQL queries are used to retrieve and manage the table's records in this database language.

 

·       Simple to use

 

MySQL is a simple database to work with. We merely need to learn the fundamentals of SQL. Only a few simple SQL statements are required to build and interact with MySQL.

 

·       It is safe.

 

MySQL has a strong data security layer in place to keep sensitive data safe from hackers. In addition, MySQL encrypts passwords.

 

·       Architecture of Client/Server

 

A client/server architecture is followed by MySQL. A database server (MySQL) and an unlimited number of clients (application applications) communicate with the server, allowing them to query data, make changes, and so on.

 

·       Downloading is completely free.

 

MySQL is free to use, thus we can get it for free from the MySQL official website.

 

·       It's adaptable.

 

MySQL is scalable because it supports multi-threading. It can deal with virtually any quantity of data, up to 50 million rows or more. Approximately 4 GB is the default file size limit. However, we can theoretically boost this number to 8 TB of data.

 

·       Speed

 

MySQL is regarded as one of the fastest database languages, as evidenced by numerous benchmark tests.

 

·       High degree of adaptability

 

MySQL is particularly adaptable since it supports a huge range of embedded applications.

 

·       Many OS systems are supported.

 

MySQL can run on a variety of operating systems, including Novell NetWare, Windows* Linux*, UNIX* (including Sun* Solaris*, AIX, and DEC* UNIX), OS/2, FreeBSD*, and others. MySQL also allows the clients to run on the same computer as the server or on a separate machine (communication via a local network or the Internet).

 

·       Allows you to go back in time.

 

MySQL allows you to roll back, commit, and recover from a crash.

 

·       Efficiency of memory

 

Its efficiency is good due to the fact that memory leakage is minimal.

 

·       High-Efficiency

 

Because of its unique storage engine architecture, MySQL is faster, more reliable, and less expensive. It achieves exceptionally good performance results when compared to other databases without sacrificing any of the software's critical features. Because of the different cache memory, it features a quick loading utility.

 

·       Productivity is high.

 

Triggers, stored procedures, and views are all used in MySQL to help developers be more productive.

 

·       Platform-unaffected

 

It can be downloaded, installed, and run on the majority of operating systems.

 

·       Partitioning

 

This feature boosts performance and allows for quick handling of huge databases.

 

·       Support for Graphical User Interface

 

MySQL offers the "MySQL Workbench," a unified visual database graphical user interface tool for database architects, developers, and database administrators. MySQL Workbench includes SQL development, data modeling, data migration, and server configuration, user administration, backup, and other administration utilities. From MySQL Server version 5.6 and higher, the user interface is fully supported.

 

·       Support for two passwords

 

MySQL version 8.0 supports dual passwords: one is the current password, and the other is a backup password that we can use to switch to the new one.

 

c.    Drawback of MySQL:


·       ROLE, COMMIT, and stored procedures are not supported in MySQL versions lower than 5.0.

·       MySQL does not support very big database sizes as well as other databases.

·       MySQL is inefficient in handling transactions and is prone to data corruption.

·       In comparison to commercial databases, MySQL is accused of lacking a good development and debugging tool.

·       SQL check constraints are not supported by MySQL.


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



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

Thanks for sharing
View more
  • x
  • convention:

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

  • x
  • convention:

Vien
Created Dec 31, 2021 04:43:40

Good share
View more
  • x
  • convention:

zaheernew
zaheernew Created Dec 31, 2021 04:56:44 (0) (0)
Keep in touch, I will share more n more about MySQL  
Rumana
Created Dec 31, 2021 06:03:15

The Series of MySQL -1- Basic of MySQL - EP 01_02-4572247-1
View more
  • x
  • convention:

faysalji
Moderator Author Created Jan 2, 2022 12:02:06

Thanks for sharing
View more
  • x
  • convention:

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

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

zaheernew
MVE Author Created Jan 9, 2022 06:21:16

@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:36:42

The Series of MySQL -1- Basic of MySQL - EP 01_02-4588503-1
View more
  • x
  • convention:

Sara_Obaid
Created Jan 10, 2022 05:32:12

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.