Author Archives: user

MySQL − Queries Table of content MySQL is an open-source relational management system (RDBMS) that allows us to store and manage data or information. The queries in MySQL are commands that are used to retrieve or manipulate the data from a database table. Following are the commonly used commands in MySQL: SELECT, UPDATE, DELETE, INSERT […]

MySQL – Derived Tables Table of content MySQL Derived Tables The Derived tables are pretty much what their name describes: they are the tables that are derived from another MySQL database table (main table). In other words, the derived table is a virtual result-set obtained from a SELECT statement given as a subquery to another […]

MySQL – Table Locking Table of content MySQL database provides a multi-user environment, that allows multiple clients to access the database at the same time. To run this environment smoothly, MySQL introduced the concept of locks. A client in a session can lock a certain table they are working on, in order to prevent other […]