What is MySql ?

MySQL is a relational database management system based on the Structured Query Language, which is the popular language for accessing and managing the records in the database. MySQL is open-source and free software. It is supported by Oracle Company. Database is a collection of related data and data is a collection of facts and figures that can be processed to produce information. Mostly data represents recordable facts. Data aids in producing information, which is based on facts. For example, if we have data about marks obtained by all students, we can then conclude about toppers and average marks. A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information.

Some basic points about Database

  • Database − A database is a collection of tables, with related data.
  • Table − A table is a matrix with data. A table in a database looks like a simple spreadsheet.
  • Column − One column (data element) contains data of one and the same kind, for example the column postcode.
  • Row − A row (= tuple, entry or record) is a group of related data, for example the data of one subscription.
  • Primary Key − A primary key is unique. A key value can not occur twice in one table. With a key, you can only find one row.
  • Foreign Key − A foreign key is the linking pin between two tables.