MySQL Tutorial
Introduction Installation of MySQL Getting MySQL server information RDBMS Concepts Data Definition Language Data types Managing Databases Managing Tables Managing Views Inserting records in a table Updating records in a table Deleting records from a table Retrieving Records Data Control Language Variables in MySQL Procedures in MySQL Built-In functions in MySQL User Defined functions in MySQL Triggers in MySQL Cursors in MySQL Transaction control Event scheduler Tuning MySQL Server Performance Managing users Importing and Exporting data Database Testing Workbench PHPMyAdminIntroduction to MySQL
MySQL is a relational database management system. First version of MySQL was released in 1995. It is developed by David Axmark and Michael Widenius. It has got below features.- Open source and cross platform
- Used in LAMP and WAMP
- Many popular applications use MySQL like WordPress, phpBB, Drupal, Joomla
- Supports stored procedures, triggers, functions, cursors
- Supports updatable views
- Many GUI apps are available for managing MySQL server like MySQL Workbench, phpMyAdmin, Toad
- We can also manage the server through command line
- APIs in all major programming languages are available to work with MySQL
Web development and Automation testing
solutions delivered!!