Got it

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

Latest reply: Feb 27, 2022 17:04:51 905 22 17 0 0

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

 

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

b.   Introduction of Database

c.    Introduction of MySQL

d.   History of MySQL

 

a.    Basic of MySQL:


MySQL tutorial covers both fundamental and advanced MySQL principles. The series of MySQL is suitable for both beginners and experts.

MySQL is a relational database management system based on the Structured Query Language (SQL), the most widely used language for accessing and managing database records. Under the GNU license, MySQL is open-source and free software. Oracle Corporation backs it up.

The series of MySQL covers all aspects of the MySQL database, including how to manage the database and manipulate data using SQL queries. Insert records, update records, delete records, select records, create tables, drop tables, and so on are examples of these queries.

 

b.   Introduction of Database:


Before mastering MySQL, it's critical to comprehend the database. A database is a program that organizes and saves a collection of records. It is very simple for the user to access and manage. It allows us to rapidly access essential information by organizing data into tables, rows, columns, and indexes. Each database has its own API for conducting database tasks like generating, managing, accessing, and finding the information it holds. Many databases are available today, including MySQL, Sybase, Oracle, MongoDB, PostgreSQL, SQL Server, and others. In this section, we'll mostly focus on MySQL.

 

c.    Introduction of MySQL:


MySQL is the most widely used database management system software for managing relational databases today. It is an open-source database that is supported by the Oracle Corporation. In comparison to Microsoft SQL Server and Oracle Database, it is a quick, scalable, and simple to use database management system. It's frequently combined with PHP scripts to build powerful and dynamic server-side or web-based enterprise applications.

 

MySQL AB, a Swedish business, created, marketed, and supported it, and it was written in the C and C++ programming languages. MySQL is used by many small and large businesses. MySQL uses the C, C++, and Java programming languages to support a variety of operating systems, including Windows, Linux, macOS, and others.

 

MySQL is a Relational Database Management System (RDBMS) that offers a variety of features, including:

 

·       It allows us to use tables, rows, columns, and indexes to perform database operations.

·       Tables (collection of rows and columns), also known as relations, are used to construct database relationships.

·       It ensures that the Referential Integrity between rows or columns of different tables is maintained.

·       It allows us to automatically update the table indexes.

·       It employs a number of SQL queries and integrates useful data from many columns for end-users.

 

d.   History of MySQL:


The MySQL project began in 1979 when MySQL's creator Michael Widenius created an in-house database tool called UNIREG for database management. Following then, UNIREG was rewritten in a variety of languages and expanded to handle large databases. Michael Widenius contacted David Hughes, the inventor of mSQL, after some time to ask if Hughes was interested in linking mSQL to UNIREG's B+ ISAM handler to offer to an index to mSQL. MySQL came into being in this manner.


cccc

 

Source: 

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

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


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


Link: 


Main:


EP 01_02:

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



EP 01_03:



EP 01_04:


EP 01_05:

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





M M Zaheer Hussain

Stay Safe!

tt

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

  • x
  • convention:

Saqib123
Created Dec 29, 2021 16:49:45

Thanks for sharing
View more
  • x
  • convention:

nagu
Created Dec 30, 2021 06:44:04

Good to know. Thank you
View more
  • x
  • convention:

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

  • x
  • convention:

Rumana
Created Dec 31, 2021 06:03:22

The Series of MySQL -1- Basic of MySQL - EP 01_01-4572249-1
View more
  • x
  • convention:

faysalji
Author Created Jan 2, 2022 12:01:52

Thanks for sharing
View more
  • x
  • convention:

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

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

The Series of MySQL -1- Basic of MySQL - EP 01_01-4588499-1
View more
  • x
  • convention:

amr_rashedy
MVE Author Created Jan 9, 2022 18:23:26

Thanks for sharing
View more
  • x
  • convention:

lucian2003
Created Jan 10, 2022 01:45:04

Interesting
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.