SQL Database

html5 and css3


MySQL is a relational database management system (RDBMS) developed by Oracle that is based on structured query language (SQL). A database is a structured collection of data.

How It Works

  • The MySQL server is the manager of the database system. It handles all your database instructions.
  • The MySQL server then creates a subdirectory in its data directory, names the new subdirectory newdata, and puts the necessary files with the required format into the newdata subdirectory.
  • Eliminate manual database management
  • The MySQL server is usually set up so that it starts when the computer starts and continues running all the time. This is the usual setup for a website.
  • SQL operates on a relational database, which consists of tables that hold data.
  • DDL statements are used to define the structure and schema of the database.
  • DML statements are used to manipulate data stored in the database.
  • DQL statements are used to query and retrieve data from the database.
  • DCL statements are used to control user access and permissions on the database.
  • The SELECT statement is the primary means of retrieving data from a database.
  • SQL provides the WHERE clause to filter data based on specific conditions.
  • SQL allows you to combine data from multiple tables using JOIN operations.
  • SQL provides aggregate functions, such as SUM, COUNT, AVG, MIN, and MAX, to perform calculations on groups of rows.
  • SQL enables you to sort query results using the ORDER BY clause.
  • SQL provides commands like INSERT, UPDATE, and DELETE to modify data in the database.
  • MySQL along with a myriad of other databases store data and indexes so that you can access the data quickly, zeroing in on the piece of information you are looking for by accessing the index that gets you to it the fastest.
  • The MySQL Database Software is a client/server system that consists of a multithreaded SQL server that supports different back ends, several different client programs and libraries, administrative tools, and a wide range of application programming interfaces (APIs).
  • SQL allows the creation of views, which are virtual tables derived

Why MySQL?

The database is free and open source with a commercial license available (MySQL is now owned by Oracle after they bought Sun). Common applications for MySQL include php and java based web applications that require a DB storage backend, e.g. Dokuwiki, Joomla, xwiki

MySQL has one major advantage, since it is free, it is usually available on shared hosting packages and can be easily set up in a Linux, Unix or Windows environment. If a web application requires more than database, requires load balancing or sharding