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 PHPMyAdminworkbench in MySQL
Workbench allows you to manage your MySQL database very easily through GUI. You can do all database operations in MySQL workbench. Sometimes, Workbench does not show the information_schema database. So you have to edit the preferences to show these metadata schemas.To edit the schema, table or triggers, you need to right click on table name and then click on Alter Table.
Web development and Automation testing
solutions delivered!!