Jump to content
Changes to the Jaspersoft community edition download ×

  • MySQL workbench - table data import and export procedure

    sadakar
     Share
    This is a redistribution of import and export features of MySQL workbench.


    6.5.1 Table Data Export and Import Wizard


    https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-table.html



    he wizard is accessible from the object browser's context menu by right-clicking on a table and choose either Table Data Export Wizard orTable Data Import Wizard.
    Figure 6.14 Table Data Wizards: Open
    Table Data Wizards: Open

    Table Data Export Wizard

    Export table data to either a JSON or CSV file. The following example exports the sakila.actor table to a CSV file.
    Figure 6.15 Table Data Export: Source
    Table Data Export: Source

    Figure 6.16 Table Data Export: CSV Configuration
    Table Data Export: Configuration

    Figure 6.17 Table Data Export: Results
    Table Data Export: Results

    Table Data Import Wizard

    Import table data from either a JSON or CSV file. The following example imports the sakila.actor table from a CSV file.
    Figure 6.18 Table Data Import: CSV Source
    Table Data Import: CSV Source

    Figure 6.19 Table Data Import: Destination Table
    Table Data Import: Destination Table

    Figure 6.20 Table Data Import: CSV Configuration
    Table Data Import: CSV Configuration

    Note
    The Encoding field should correspond with your CSV file.
    Figure 6.21 Table Data Import: Results
    Table Data Import: Results

     Share
    Go to blogs

    User Feedback

    Recommended Comments

    There are no comments to display.



    Guest
    This is now closed for further comments

×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore