Lectures List
capscom technology computer course almora

What is MYSQL

MYSQL is an RDBMS (Relational Database Management System) software, which is used to manage data in the form of tables that is also called relation in a database.
The relational database was invented by E. F. Codd.

Database

The collection of tables is called a database.

Table

The collection of rows and columns is called a table.

Rows (Record)

A horizontal row in a table is called a record because it is collection of fields.

Fields (Attributes)

Vertical lines in a table are called fields.

MYSQL used in vast forms, today most of the tech companies are using MYSQL like FACEBOOK, UBER, etc.

Some key points about mysql which makes it more popular.

  • It is open-source software.
  • It is reliable, scalable, and easy to use.
  • It is a cross-platform RDBMS.

Every table in a database is also called entities like products, users, employees.

In RDBMS two most popular keys are.

Primary Key

A key that makes a record unique in a table.
or
In a table, every row is uniquely identified by a key that is called the primary key.

Foreign Key

A key in a table pointing to the primary key in other table is called foreign key, and a foreign key may not be unique.

Author/Written by: Mr Hemant Singh (Founder)
Terms & Conditions CAPSCOM TECHNOLOGY Pvt. Ltd. का बेहतर रूप से संचालन करने के लिए यहॉ कुछ नियमें और शर्ते लागू है अगर आप कैप्सकॉम टैक्नोलॉजी में पढ़ रहे है तो यह आप पर लागू होता है।