MySQL is a database management system DBMS. The DBMS create, read, update, and delete data in the database. It also controls access to the data. The DBMS may be used directly by users or used programatically by another computer program that requires the use of database.
The storage engine is part of the DBMS that store and accesses the data. It includes indexing, searching, and manage locking of data.
SQL or structured query language is language for interacting with a DBMS.
Database is a storage of data.
Table is a single class of data.
Row and Column - organization of a table. Column - fields, Row - records.
MySQL is a database management system consist of:
Database server which manages the data and perform CRUD Create, Read, Update and Delete operations.
Set of client Libraries which are the interface for applications to connect with the database server.
Command Line Client performs all operations necessary to manage and operate the database serve.
No comments:
Post a Comment