DataGrip: MySQL engines

Today I've had a little trouble with database controlled by RDBMS MySQL. One table in this database have had MyISAM engine which doesn't support foreign keys and I've spent some time to understand why I cannot create a foreign key to this table. Every time I've tried to create a link I've got 150 MySQL error. After all I have tried to do the same thing in Valentina Studio and it gave me clear and detailed message about mistake with engines. I think it would be great if you add such thing to your tool, also it would be very nice if table's engine is shown in "Modify table" menu.

Thanks.

1 comment
Comment actions Permalink

Hello Alex,

We have this request in YouTrack, please vote for https://youtrack.jetbrains.com/issue/DBE-675 . Please see https://intellij-support.jetbrains.com/hc/en-us/articles/207241135 if you are not familiar with YouTrack.

0

Please sign in to leave a comment.