Re: MySQL Workbench: Exported SQL generates errors
Hey Sveja,
MySQL Worbench is a modelling tool. It does not enforce you to follow all the rules of the target RDBMS. So it can happen that you designed something that is not allowed on the target system (e.g. too long names or comments). MySQL Workbench SE (which is the commercial brother of MySQL Workbench OSS) has a Validation module which checks many of these problems and issues messages for them. In the OSS version, though, you have everything in your own hands and can do whatever you want, but you have to take care yourself the model can be converted into valid SQL code.
In order to find the problem examine the produced SQL script and correct your model to avoid invalid output. You can also post some errors you got here, along with the code that produced them. We might be able to help you better then.
Mike
Mike Lischke, MySQL Developer Tools
Oracle Corporation
MySQL Workbench on Github:
https://github.com/mysql/mysql-workbench
On Twitter:
https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to
http://bugs.mysql.com
MySQL documentation can be found here:
http://dev.mysql.com/doc/refman/8.0/en/
Subject
Views
Written By
Posted
3494
March 25, 2009 03:00PM
Re: MySQL Workbench: Exported SQL generates errors
2293
March 26, 2009 01:47AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.