Printable View
I need some basic explanation of MySQL. How does it helps to work in database management. It is a query language but the concept of sql working on a database server still confuses a lot. I am interested in studying this language. But before going on it I need the working introduction of the language. And I want to know the implementation of mysql.
SQL is a compact and powerful language for working with databases. Despite this compactness, it cannot be explain simply in a few chapters. MySQL is a relational database server that supports the well-known SQL (Structured Query Language) database language. Therefore, MySQL is named after the language that developers use to store, query, and later update data in a MySQL database. In short, SQL is the native language of MySQL. In this you got the following discusses on the topics. None of these topics is really significant for studying MySQL’s SQL.
SQL (Structured Query Language) is a database language used for formulating statements processed by a database server. In this case, the database server is MySQL. The first sentence of this paragraph contains three important concepts: database, database server, and database language. We begin with an explanation of each of these terms. For the implementation of mysql.
A database consists of some collection of persistent data that is used by the application systems of some given enterprise and managed by a database-management system. Therefore, card index files do not constitute a database. On the other hand, the large files of banks, insurance companies, telephone companies, and the state transport department can be considered databases. These databases contain data about addresses, account balances, car registration plates, weights of vehicles, and so on.
For example to the implementation of mysql, the company you work for probably has its own computers, which are used to store salary-related data. Data in a database becomes useful only if something is done with it. According to the definition, data in the database is managed by a separate programming system. This system is called a database server or database management system (DBMS). MySQL is such a database server.
A database server permit the users to process data stored in a database. Without a database server, it is not possible to look at data in the database or to update or delete superseded data. The database server alone knows where and how data is stored. A definition of a database server appears in [ELMA06], A database server is a collection of programs that permit the users to generate and maintain the a database.