MySQL Workbench for Beginners
MySQL Workbench for Beginners, Perform Data Modelling with MySQL Workbench.
MySQL Workbench is a visual database designing and modeling access tool for MySQL server relational database. It facilitates the creation of new physical data models and modification of existing MySQL databases with reverse/forward engineering and change management functions. The purpose of MySQL workbench is to provide the interface to work with databases more easily and in a more structured way.
MySQL workbench has tools that allow developers and database administrators to visually create physical database design models that can be easily translated into MySQL databases using forward engineering.
MySQL workbench supports the creation of multiple models in the same environment.
It supports all objects such as tables, views, stored procedures, triggers, etc. that make up a database.
MySQL workbench has a built-in model validating utility that reports any issues that might be found to the data modeler.
It also allows for different modeling notations and can be extended by using LUA a scripting language.
MySQL Workbench has a built-in SQL visual editor. The Visual SQL editor allows developers to build, edit and run queries against MySQL server databases. It has utilities for viewing data and exporting it. The syntax color highlighters help developers easily write and debug SQL statements.
Multiple queries can be run and results are automatically displayed in different tabs. The queries are also saved in the history panel for later retrieval and running.
