Hey Wendy,
> Compare to MS SQL DB Designer, EMS DB Designer for
> MySQL and SQLyog fro MySQL, then I found WB very
> not user friendly.
Let's see if I can help you. I assume you have MySQL Workbench OSS working on Windows (XP? Vista?).
> 1. A simple task like "PRESS A KEY TO SELECT A
> VALUE FROM DROPDOWN LIST" can not apply to WB!
I wonder where you see this. I just fired up WB and picked a drop down box, in this case I created a new table on the overview page, which opens an editor and then I used the collation drop down box to select a new collation. Works well with my keyboard. Maybe it is just a single drop down box that does not work, which would then be a bug.
> 2. Can not DOUBLE CLICK to edit the table, you
> must RIGHT CLICK then select EDIT
Are you on the overview page or a diagram page? Both work for me so I wonder if there is another problem, not related to MySQL Workbench.
> 3. Default value of Varchar is 45. Where this 45
> idea come from? And where to edit this as next
> default value?
This value was set once as a temporary solution but we never adjusted it properly to make it customizable (like it is with the primary key default data type). We will change this in a future release. Thanks for noting that.
> 4. The relation ship FIELD can not point to
> RELATED field, i.e: I can not move the
> relationship LINE to USER ID, this line only
> located on the center of table side.
For relationship notations we have different styles to choose from. One is "Connect to columns", which is probably what you want. However, this is a feature only available in the SE version of Workbench.
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/