All geek questions in one place

Import table source data into a .mwb model file

How to import table source data into a .mwb file? I know that each table has a tab inserts, but I would like to import about 200 entries, and I do not want to do it manually.

+3
source share
2 answers

This is not possible in the modern version of MySQL Workbench. In fact, there is no way to simulate data - you can upload it only to the server (and not to the model). The only way now is to edit one by one, which is impractical. Even if you rework the data table, the EER model insertion table will be empty. You will notice that right-clicking on the row of the inserts tab gives several options for greyed out, including "load from file". I suspect that the team did not have time to implement them or something like that. Anyway, there is a simple job if you know phpMyAdmin, which seems to handle CSV or MySQL Workbench files well, which I didn't work with CSV files at all.

Decision:

MySQL Workbench, . CSV - Excel CSV - . , , Excel, , Workbench, , - Excel.

, , , .

+5

. , insert script, 1. : P 2. , :

http://download.oracle.com/docs/cd/E19078-01/mysql/mysql-workbench/wb-data-modeling.html#wb-reverse-engineering

7.7.9.1. Create Script

script File, Import, Reverse Engineer MySQL Create script.... , SQL script, sql.

(DDL) script, mysqldump db_name --no-data > script_file.sql. -no-data , script DDL. , script, DML, ; .

, , ( ) - , sql.: (

0

Source: https://habr.com/ru/post/1771057/

More articles:


All Articles