I'm working on MySQL Workbench Version 6.1 (6.1.4.11773 build 1454). I see too bugs in Workbench. But there are issue only on using gui. There are no bug or issue with codes, query so manually. I cant change auto increment with checkbox of alter table. But i can change with codes. I can't set foreign key without codes. There is a checkbox issue of setting foreign key referenced column. But I can set same foreign key with codes. And When I set a Datatype look like "INT(11)", It's working but then It's looking this "(11)". I see a lot of thing like these. Are these bugs?
相关问题
- sqlyog export query result as csv
- NOT DISTINCT query in mySQL
- MySQL: conduct a basic search
- Why sometimes there is one of more gap(s) in the v
- mySQL alter table on update, current timestamp
As I mentioned here before, I could only solved the issue with changing the "Regional format" setting of Windows 10 OS from "Turkish (Turkey)" to "English (United states)".
if you run mysql workbench in Turkish locale, it will not work correctly. Create a table with "INT" fields. Then save it. then try to alter the table. it will only display (11) as the field type. Because in Turkish locale, i and I are different letters. (corresponding to ı and İ) and this causes a problems while trying to create foreign keys. because it cannot find any columns with type (11).
Go to your Server->Options File and change these options to
It worked for me.