MySQL Forums
Forum List  »  MySQL Workbench

Re: Collecting ideas for Workbench 5.1 - SQL IDE
Posted by: Boris Arkenaar
Date: July 19, 2008 07:22AM

First of all, thanks for this usefull application.

I have two things:

- When you export you database to an SQL CREATE script on top of that script you have the following line:
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';
In my ini file I have my sql-mode set to:
'TRADITIONAL,ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO,PIPES_AS_CONCAT,NO_ENGINE_SUBSTITUTION'.
So every time I export my database I have to remove that line from the script in order to use my own sql-mode.
It would be nice if you could specify what settings will be used in the script.

- I like to add comments to tables and columns, MySQL has a limit of 60 characters for a table comment and a limit of 255 characters for a column comment. Unfortunately the workbench doesn't limit you whe writing a comment, wich will result in an error when excecuting the exported sql script, when you have specified a comment of to much characters. So you have to count the characters every time you write a comment.
It would be nice if the workbench would limit to the amount of characters allowed when typing a comment.


Good luck with the project.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Collecting ideas for Workbench 5.1 - SQL IDE
3049
July 19, 2008 07:22AM
3745
February 06, 2009 07:30AM
2666
March 12, 2009 01:38AM


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.