Functions In Table Editor
已回答
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?
请先登录再写评论。
There is no feature like that, but can you explain more about escape sequence in Workbench? How does it work?
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.
Got it, thanks!
Can I ask you to create a feature request? https://youtrack.jetbrains.com/issues/DBE
Already done: https://youtrack.jetbrains.com/issue/DBE-7422