Introduction to MySQL Database

MySQL Database – Introduction

x
Demo - Online School Documents Processing System Free Bootstrap Template
MySQL is a relational database management system (RDBMS) that uses Structured Query Language (SQL) . MySQL RDBMS is an open source application which means it is free to use under the GNU General Public License.

Structured Query Language (SQL) – the most common language for relational system, used to insert, update, delete and retrieve content in the database.

Example applications which uses MySQL: Joomla, Drupal, WordPress,phpBB, Magento, Moodle.

SQL Commands Categories

Data Definition Language (DDL) – DDL consists of commands that specify the database scheme. It is also used to create and destroy databases and database objects.

Example of DDL commands: CREATE, DROP, ALTER

Data Manipulation Language (DML) – DML is used to add new records, update records, delete records and retrieve records. It enables you to access and manipulate data in the database.

Example of DML commands: SELECT, INSERT, UPDATE, DELETE

Data Control Language (DCL) – DCL consists of commands to create user privileges and control access to data

Example of DCL commands: GRANT, REVOKE

Understanding Tables, Records, and Fields

Every database is composed of one or more tables. Tables are the foundation of every Relational Database Management System and one of those is MySQL.

Table – A set of data arranged in columns and rows. The columns represent characteristics of stored data and the rows represent actual data entries.

Table columns describe the data types and particular attribute of the data.

Table rows contain the actual data.

, , ,

Post navigation

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.