MYSQL

Mysql

• MySQL is an open-source relational database management system.
•  Its name is a combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language
• Original author : MySQL AB
• Developer : Oracle Corporation
• Initial release 23 May 1995
• Written in C, C++
• Type : RDBMS
• License : GPLv2 or proprietary
• SQL stands for Structured Query Language
• SQL lets you access and manipulate databases

Advantage Of  Mysql

• Data Security. ...
• On-Demand Scalability. ...
  
• High Performance. ...
• Round-the-clock Uptime. ...
• Comprehensive Transactional Support. ...
• Complete Workflow Control. ...
• Reduced Total Cost of Ownership. ...
• The Flexibility of Open Source.

Disadvantage Of Mysql

• It’s Got A Few Stability Issues
• It Suffers From Relatively Poor Performance Scaling
• Development Is Not Community Driven – and Hence Has Lagged
• Its Functionality Tends To Be Heavily Dependant On Addons
• Developers May Find Some Of Its Limitations To Be Frustrating

Keywords Of Mysql

• DROP DATABASE databaseName -- Delete the database (irrecoverable!)
• DROP DATABASE IF EXISTS databaseName -- Delete if it exists
  
• CREATE DATABASE databaseName -- Create a new database
• CREATE DATABASE IF NOT EXISTS databaseName -- Create only if it does not exists
• SHOW DATABASES -- Show all the databases in this server
• USE databaseName -- Set the default (current) database
• SELECT DATABASE -- Show the default database
• SHOW CREATE DATABASE databaseName -- Show the CREATE DATABASE statement

Example Of Mysql

mysql> SHOW DATABASES;

O/P:

+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
........