MySQL Tutorial

http://www.w3resource.com/mysql/mysql-tutorials.php

• MySQL Home
• MySQL installation
• MySQL administration tools
• MySQL storage engines (table types)
• MySQL data types
• Connecting to and disconnecting from MySQL
• Creating databases and tables
• Altering tables
• Inserting and deleting records
• MySQL basic select statement
• Aggregate functions and grouping
• MySQL functions and operators
• Advance queries in mysql
• Advanced creating table
• Creating view
• Update table
• MySQL drop
• Exporting and importing data between mysql and microsoft excel
• MySQL backup and restore
  

  Introduction

  MySQL tutorial of w3resource is a comprehensive tutorial to learn MySQL. We have hundreds of examples covered, often with PHP code. This helps you to learn how to create PHP-MySQL based web applications.

  What is MySQL

  1. MySQL is a open source Relational Database Management System developed by Michael Widenius and David Axmark in 1994.
  2. MySQL is very popular when it comes to Web development. It is widely-used as the database component of LAMP web application software stack.
  3. Source code of MySQL is available under GNU General Public License.
  4. MySQL is maintained by a Swedish company MySQL AB, now owned by Oracle Corporation.
  

  Who uses MySQL

  1. Some of the most visited websites like Flickr, Facebook, Wikipedia, Google (not for search), Nokia.com, YouTube.
  2. Some most widely used Content Management Systems like WordPress, phpBB, Drupal.
  3. Last but not least, a large number of web developers across the world.

  What programming languages can be used with MySQL

  You can use C, C++, PHP, ASP, Cold Fusion, Java etc.

  On which platforms do MySQL work

  AIX, BSDi, FreeBSD, HP-UX, i5/OS, Linux, Mac OS X, NetBSD, Novell NetWare, OpenBSD, OpenSolaris, eComStation, OS/2 Warp, QNX, IRIX, Solaris, Symbian, SunOS, SCO OpenServer, SCO UnixWare, Sanos, Tru64 and Microsoft Windows.

  Some of the widely used MySQL front ends (tools for managing MySQL)

  Tools	Description
  MySQL Workbench	Official, GUI Based
  MySQL GUI Tools	Official, GUI Based
  phpMyAdmin	Third party, Free, Web based
  HeidiSQL	Third party, Free, For Windows
  Adminer	Third party, Free
  DBEdit	Third party, Free
  dbForge GUI Tools	Third party, Free
  Navicat	Third party, Commercial
  Maatkit	Third party, Command line, free
  MySQL Sandbox	Third party, Command line, free

  
  

  Key features of MySQL

  1. MySQL follows ANSI SQL 99, the standard SQL.
  2. Cross Platform.
  3. RDBMS features like Stored procedures, Triggers, Cursors, Views which can be updated, True Varchar support, Query caching, Sub-SELECT etc.
  4.Support for replication.
  5. Support for hotbackup.
  6. Support for MySQL cluster.
  7. Full-text indexing and searching.
  8. SSL support.
  9. Partial Unicode support.