mysql-workbench

Suppress Comment in SQL Generation MySQL WorkBench

MySQL workbench can export a MYSQL data model to SQL create table script. But can I choose to suppress comments when doing the export? If yes, how? ...

Export MySQL Workbench data model directly to Schema YML in Propel/ Symfony

Is there any plugin that directly exports MYSQL Workbench data model directly to YML for Propel consumption? ...

Propel with Schema.xml

Is it possible to generate model in Propel using Schema.xml, instead of Schema.yml? There was once upon a time when xml was used for database generation in Propel, but it had been dropped in favor of yml. I should go for yml if I were handcoding my database schema, but now since I directly export my database schema from MySQL workbench ...

How do create a python module for MySQL Workbench?

I am trying to create a simple Python module for MySQL Workbench 5.1.17 SE however I cannot seem to register the module, that is, it is not displaying under the Plugins->Catalog menu. The documentation appears to be rather weak at this time, the best I have found is Python Scripting in Workbench. There isn't much in the way of instruct...

MySQL Workbench symbol reference

I'm looking at a database diagram generated by MySQL Workbench (actually, DBDesigner4), but I'm not familiar with it so I couldn't figure out some of the symbols it uses for relationships and fields. Does anyone know a good legend? ...

Using MySQL Workbench

I am trying to create a graphical representation of table relations using "Mysql workbench". I double clicked on "MySQL Model" tab and added Diagram. But I can not figure out how to display the tables from current DB. Any help? ...

Is it possible to save MySQL Workbench files as plain XML?

DB Designer had a lot of bugs but one outstanding feature was that database models were saved in plain XML by default. This allowed a user to diff file versions via SVN or Beyond Compare, easily finding any changes made to the database. Unfortunately, DB Designer's succsssor, MySQL Workbench, stores files in a proprietary MVW file form...

MySQL Workbench's treatment of foreign keys

How do I force MySQL Workbench, when using a foreign key, to perform an INSERT to my referenced table before the INSERT to the referencing table. Without the obvious solution of editing the generated SQL by hand? ...

Why does MySQL Workbench produce incompatible syntax for simple table create on export?

Using MySQL Workbench 5.0.30 OSS, I try to produce a simple SQL script to create tables, yet what it produces doesn't seem to be the least bit compatible with MySQL Ver 14.14 Distrib 5.1.42, for Win32 (ia32). Update: Here is the SQL generated from MySQL Workbench: CREATE TABLE IF NOT EXISTS `mydb`.`Table1` ( `idClaimNum` NOT NULL ,...

Create database relationship by MySQL Workbench

I'm try to create a foreign key between tables by using MySQL Workbench. But I don't know why I can't tick the checkbox to select a field in order to map with another field in another table. Maybe it require both field has the same type (and other conditions??) So can you tell me the criteria to create relationship using foreign key and ...

What's wrong with this MySQL Stored Function?

Having trouble getting this to apply in MySQL Workbench 5.2.15 DELIMITER // CREATE DEFINER=`potts`@`%` FUNCTION `potts`.`fn_create_category_test` (test_arg VARCHAR(50)) RETURNS int BEGIN DECLARE new_id int; SET new_id = 8; RETURN new_id; END// The actual function will have a lot more between BEG...

MySQL Workbench: Generate a bunch of rows?

I have a MySQL workbench model that I've used to generate a schema. To play around with it, I'd like a bunch of fake data. Is there an easy way to generate this, or must I do it by hand? ...

MySQL Workbench - How to synchronize the EER Diagram

I am creating a visual representation of my existing database with MySQL Workbench and I am able to synchronize the models with the "Database -> Synchronize Model..." menu. However, every time I synchronize (update) my model, I have to recreate the EER Diagram and rearrange all the tables. Is there a way to update or synchronize the EER ...

How to get a table creation script in MySQL Workbench?

I am rolling back to MySQL GUI Tools' MySQL Query Browser since I can't find the shortcut to get a table's creation script in MySQL Workbench. ...

How do I run a script on/in a mysql database?

I have created a MySQL database using MySQL Workbench. It has about 20 tables. I cannot figure out how to run scripts on the database. Basically, I want to make a database creation script which will allow me to create my database on any other MySQL server. ...

Is there a way to model table inheritance using MySQL Workbench?

Is there a way to model table inheritance using MySQL Workbench? I'd like the ERD to look similar to the left side of this image: ...

MySQL foreign key creation with alter table command

I created some tables using MySQL Workbench, and then did forward ‘forward engineer’ to create scripts to create these tables. BUT, the scripts lead me to a number of problems. One of which involves the foreign keys. So I tried creating separate foreign key additions using alter table and I am still getting problems. The code is below (t...

Synchronize model in MySQL Workbench

After reading the documentation for MySQL Workbench I got the impression that it's possible to alter a database in the server (e.g. add a new column) and later incorporate the DDL changes into your EER diagram. At least, it has a Synchronize Model option in the Database menu. I found it a nice feature because I could use a graphic modell...

MySQL Workbench vs phpMyAdmin

I've only used phpMyAdmin but then I stumbled upon MySQL Workbench that looks promising. I wonder if someone has tried it out and could give your thoughts about it compared to phpMyAdmin. Could it replace phpMyAdmin completely? ...

Hibernate pojo file issues

Hi all I am currently using netbeans for a project. I have created my db using MySQL Workbench. I have two relationships that are one to one. However once I create the POJOs using netbeans hibernate mapping files tools they are being created as one to many. I have tried reversing the db within workbench and the relationships are shown...