Functions In Table Editor

Answered

Is it possible to use a function when you're in the table editor view (right click on a table and use "Jump to Editor")?  There are functions that would be handy to use like uuid() or sha1() or similar when adding a new record, but it doesn't appear that you can directly do that.  Is there an escape sequence it looks for to do that like MySQL Workbench or is this not an existing feature?

4 comments
Comment actions Permalink

There is no feature like that, but can you explain more about escape sequence in Workbench? How does it work?

0
Comment actions Permalink

In MySQL Workbench, you can type something like:

\func md5('fred')

And that would execute the md5 function in the update/insert statement.  In SQLyog, you're able to just type in the function and it will recognize it and execute it as opposed to putting it in quotes.

0
Comment actions Permalink

Got it, thanks!

Can I ask you to create a feature request? https://youtrack.jetbrains.com/issues/DBE

0

Please sign in to leave a comment.