Generator invoking MySQL
Printed From: MetaCase
Category:
Forum Name: MetaEdit+
Forum Description: All topics relating to MetaEdit+ or DSM
URL: https://www.metacase.com/forums/forum_posts.asp?TID=701
Printed Date: 27.Mar.2026 at 00:26
Software Version: Web Wiz Forums 12.05 - http://www.webwizforums.com
Topic: Generator invoking MySQL
Posted By: knto
Subject: Generator invoking MySQL
Date Posted: 17.May.2013 at 17:31
Good afternoon  I'm a newbie, and I have an inquiry. I want to know if it is possible with metaEdit to create a generator who call mysql and makes some inserts. I get to the point to generate the SQL sentences out of the model. Can anyone please give me an insight on how I can do it? I will be great  Thanks and best regards. |
Replies:
Posted By: janne
Date Posted: 20.May.2013 at 09:59
|
Please see the 'Orders and produts' sample in Example project (Entity Relationship Diagram), there exists 'Create SQL' generator for creating the tables and attribute definitions and constraints. In the similar manner you could create your mysql-specific generator or customize the existing one to contain the insertion commands as well. In the end of the generator you may execute the SQL statements in a script file (batch file) : external 'mysql YOUR_DB <your_script.sql>' execute [Edit: removed incorrect double quotes -Steve] |