Scribd Logo
Upload

Welcome to Scribd!

  • 41 views

    Introduction Mysql Workbench: Pinal Dave @pinaldave

    Uploaded by

    Raja O Romeyo Naveen
    MySQL Workbench is a visual tool for database design, creation, administration, and migration. It provides features for database development like SQL editing and result viewing, database design through entity relationship diagramming and reverse engineering of existing databases, and administration of database instances, users, and logs. Key capabilities include visual modeling, schema synchronization, data migration between databases, and scripting support through Python and Lua.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Introduction Mysql Workbench: Pinal Dave @pinaldave

    Uploaded by

    Raja O Romeyo Naveen
    41 views5 pages
    MySQL Workbench is a visual tool for database design, creation, administration, and migration. It provides features for database development like SQL editing and result viewing, database design through entity relationship diagramming and reverse engineering of existing databases, and administration of database instances, users, and logs. Key capabilities include visual modeling, schema synchronization, data migration between databases, and scripting support through Python and Lua.

    Original Title

    4-mysql-fundamentals-part1-04-workbench-slides

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    MySQL Workbench is a visual tool for database design, creation, administration, and migration. It provides features for database development like SQL editing and result viewing, database design through entity relationship diagramming and reverse engineering of existing databases, and administration of database instances, users, and logs. Key capabilities include visual modeling, schema synchronization, data migration between databases, and scripting support through Python and Lua.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    41 views5 pages

    Introduction Mysql Workbench: Pinal Dave @pinaldave

    Uploaded by

    Raja O Romeyo Naveen
    MySQL Workbench is a visual tool for database design, creation, administration, and migration. It provides features for database development like SQL editing and result viewing, database design through entity relationship diagramming and reverse engineering of existing databases, and administration of database instances, users, and logs. Key capabilities include visual modeling, schema synchronization, data migration between databases, and scripting support through Python and Lua.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 5

    Introduction MySQL Workbench

    Pinal Dave
    @pinaldave
    Outline

     Visual Database Design Tools


     Development
     Design
     Administration
     Features
    MySQL Workbench Features

     Database Development  Database Administration


     Schema object browsing  Start and stop of database instances
     SQL syntax highlighter and statement
     Instance configuration
    parser
     Multiple-, editable result sets  Database account management
     SQL snippets collections  Instance variables browsing
     SSH connection tunneling  Log file browsing
     Unicode support  Data dump export/import
     Database Designing
     Database Migration
     ER diagramming
     Any ODBC compliant database
     Drag'n'Drop visual modeling
     Native support: Microsoft SQL Server,
     Reverse engineering from SQL Scripts and
    PostgreSQL, Sybase ASE
    live database
     Miscellaneous
     Forward engineering to SQL Scripts and
    live database  Database Connection & Instance
    Management
     Schema synchronization
     Wizard driven action items
     Printing of models
     Fully scriptable with Python and Lua
     Import from fabFORCE.net DBDesigner4
     Support for custom plugins

    Ref: http://en.wikipedia.org/wiki/MySQL_Workbench
    Starting MySQL Workbench

    Start >> All Programs >> MySQL >> MySQL workbench


    Summary in Sixty Seconds

    #1 MySQL Workbench is divided into three major


    sections i) Development ii) Modeling iii) Administration

    #2 We can retrieve, view, edit or delete data from SQL


    Editor of SQL Development section

    #3 We can create database model as well reverse


    engineer database from Data Modeling section

    #4 We can start, stop and manage MySQL instance from


    Server Administration section

    #5 Remember, we can use MySQL Command Line Editor


    if we have no access to MySQL Workbench

    #6 Download MySQL Workbench from


    http://www.mysql.com/downloads/workbench/

    You might also like