MySQL


MySQL (officially pronounced as "My S-Q-L") is an open-source relational database management system (RDBMS).

MySQL is a central component of the LAMP open-source web application software stack (and other "AMP" stacks). LAMP is an acronym for "Linux, Apache, MySQL, Perl/PHP/Python". Applications that use the MySQL database include: TYPO3, MODx, Joomla, WordPress,phpBB, MyBB, and Drupal.

MySQL is also used in many high-profile, large-scale websites, including Google (though not for searches), Facebook, Twitter, Flickr, and YouTube.

Module

  • Introduction
  • MySQL Installation
  • Administration
  • MySQL PHP Syntax
  • MySQL Connection
  • MySQL Create Database
  • MySQL Drop Database
  • MySQL Select Database
  • MySQL Data Types
  • MySQL Create Tables
  • MySQL Drop Tables
  • MySQL Insert Query
  • MySQL Select Query
  • MySQL Where Clause
  • MySQL Update Query
  • MySQL Delete Query
  • MySQL Like Clause
  • MySQL Sorting Results
  • MySQL Using Join
  • MySQL NULL Values
  • MySQL Regexps
  • MySQL Alter Command
  • MySQL SQL Injection
  • MySQL Procedure
  • MySQL Events
  • MySQL Trigger