mysqlworkbench

MySQL Workbench output SQL file cannot be processed by MySQL Administrator.

I have tried MySQL Workbench to create database diagrams. There is a function that lets you export your database schema as a SQL file. But this file is rejected by MySQL Administrator and will not be processed, with a message that the SQL file is generated by mysqldump program. Is there another way to process this file so that I don't ha...

Tables are empty set in MySQL

I used MySQL Workbench to generate a database and now I inserted it into the command-line client using: mysql> . C:\Documents and Settings\kdegroote\My Documents\School\2008-2009\ICT2 \Gegevensbanken\Labo\Hoofdstuk 3 oef 6\pizzasecondtry.sql For some reason, the last table won't be accepted. "Cannot create table" is the error message. ...

Table comment length in mysql

According to MySQL manual, table comments are limited to 60 characters. I'm designing the schema in MySQL Workbench, which does not enforce this limit, so I end up with writing more than 60 symbols quite often, and this causes the SQL script to fail. To tell the truth I would be quite happy with table comments being internal to my schema...

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 ...

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: ...

Syntax Error with MySql Workbench and IF Statement

Hey guys, Im migrating from T-SQL to MySql syntax and don't know how to get over this syntax error given by Workbench 5.1.18: -- -------------------------------------------------------------------------------- -- Routine DDL -- -------------------------------------------------------------------------------- DELIMITER // CREATE PROCEDUR...

How to edit an existing and working Schema in MySQL Workbench?

Hi!, is possible to conitnue or extend an existing schema with MySQL Workbench? This is the scenery: 1) We design our DB in MySQL Workbench 2) We export it as SQL file and execute it in our MySQL Server 3) We insert a lot of data and use our DB 4) We want to add more tables, fields, or anything to our Schema The 4 step is my dude, can w...

do you table can be as IN procedure in mysql?

do you table can be as IN procedure in mysql? ...