MySQL Forums
Forum List  »  MySQL Workbench

Re: MySQL Workbench: Exported SQL generates errors
Posted by: Mike Lischke
Date: March 26, 2009 01:47AM

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/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL Workbench: Exported SQL generates errors
2207
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.