MySQL Forums
Forum List  »  MySQL Workbench

Re: Collecting ideas for Workbench 5.1 - SQL IDE
Posted by: Jonathan Levin
Date: March 19, 2008 08:28AM

Well Michael

I firstly have to say what a really wonderful product Workbench is.
Having said that, I really do have 1 thing I would like to add to it.
I would like it if you could add "rules" to Workbench.
As in, under the table definitions, fields, there can be rules.
Rules like, if(field1_myage>200) then send_error "not possible"
or like, if(field2_email in ('%','$',...other funny characters) then send_error "not possible"

What I am trying to say is have validation rules, that are in a simple syntax and then afterwards, ideally have the workbench translates it to triggers.

Let the workbench keep clear and easy to manage rules for the tables that will help keep data quality high and everyone happy with a simple yet powerful way to manage their databases.

Best Regards
Jonathan Levin

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Collecting ideas for Workbench 5.1 - SQL IDE
3673
March 19, 2008 08:28AM
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.