19-12-2012, 04:17 PM
SQL
SQL.pptx (Size: 54.54 KB / Downloads: 23)
Introduction
Free SQL (Structured Query Language) database server.
licensed with the GNU General public license http://www.gnu
MySQL is a database management system.
MySQL is a relational database management system.
MySQL is Open Source Software
My SQL Features
Fully multi-threaded using kernel threads.
Works on many different platforms.
Many column types
Very fast joins using an optimized one-sweep multi-join
Full operator and function support in the SELECT and WHERE parts of queries.
You can mix tables from different databases in the same query.
A privilege and password system that is very flexible and secure.
Handles large databases.
Tested with a broad range of different compilers. (C/C++)
No memory leaks.
Full support for several different character sets.
Types of Commands
Data Definition Language (DDL)
Commands that define a database, including creating, altering, and dropping tables and establishing constraints.
Data Manipulation Language (DML)
Commands that send query to a database like add new records, delete records, update the records and select the records.
Data Control Language (DCL)
Commands that control a database, including administering privileges and committing data.