dbForge Studio for MySQL

dbForge Studio for MySQL is a universal set of MySQL GUI tools for database management, administration and development. It enables to create and execute queries, develop and debug MySQL routines, and automate MySQL database object management in the convenient environment.

http://www.devart.com/dbforge/mysql/studio/

I suggest you...

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  1. Fix start of comment detection at beginning of line

    When editing SQL code in dbForge for MySQL 7.3.137, there is a case where it fails to detect the "start of comment" delimiter, and incorrectly intreprets the remaining text on the line as SQL code. This breaks the syntax highlighter, auto-complete, and ability to save stored procedures, functions, etc.

    Specifically, when using a double-dash "--" to start a comment in MySQL, it normally requires whitespace after the double-dash to be interpreted as a start of comment delimiter. However, when the double dash is at the beginning of a line, it does not require whitespace.

    See: https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-comments.html

    Example:

    -- This is…

    1 vote
    Vote
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      You have left! (?) (thinking…)
      0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
    • При простое в работе (примерно через час) отключается таблица

      При простое в работе (примерно через час) отключается таблица.
      и постом при возобновление использования минимум ВСЕГДА ДВА раза пишет , одну и туже ошибку( Lost connection to MySQL server during query (......:3306) Table:....... ) если нажать обновить .

      а иногда вообще даже кнопка обновить исчезает и пишет что 0 записей хотя они есть. приходится переподключаться, исправьте пожалуйста, этот баг

      3 votes
      Vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        Password icon
        I agree to the terms of service
        Signed in as (Sign out)
        You have left! (?) (thinking…)
        3 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

        Вы можете попробовать увеличить значение в поле ‘Тайм-аут соединения’ на вкладке ‘Дополнительные’ окна ‘Свойства соединения базы данных’ (щёлкните правой кнопкой мыши на соединении в Проводнике и выберите ‘Изменить соединение…’ в контекстном меню). Значение, равное нулю, означает бесконечность.

      • Fix false-positive syntax error detection when using UNION

        I recently upgraded to dbForge 7.3 and discovered that the SQL syntax highlighter is incorrectly highlighting valid SQL (per MySQL 5.6) as if there is an error. Example SQL is below.

        The effect is that the word "UNION" in the SELECT statement will display the red error underline (hover text: 'Identifier' expected) and the closing parenthesis will be similarly highlighted (hover text: Unexpected symbol ')'). If you run the query, the error highlighting will disappear until the SQL is edited, at which point it will immediately return.

        -- SQL syntax highlighter bug in dbForge for MySQL 7.3.137

        DROP TEMPORARY TABLE…

        1 vote
        Vote
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          Password icon
          I agree to the terms of service
          Signed in as (Sign out)
          You have left! (?) (thinking…)
          0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
        • that you can sort all the fields or columns names of the tables

          a way to see all the fields in a table in sorted way. A-Z or Z-A.

          some tables right here have 300 columns

          1 vote
          Vote
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            Password icon
            I agree to the terms of service
            Signed in as (Sign out)
            You have left! (?) (thinking…)
            0 comments  ·  Flag idea as inappropriate…  ·  Admin →
          • Crashed automatically

            During a long time runing and I havn't do any operation, the dbForge Studio for MySQL will crashed by itsell.

            I see the windows event log like below, any solution?

            Faulting application name: dbforgemysql.exe, version: 7.3.137.0, time stamp: 0x5a5750d3
            Faulting module name: ucrtbase.dll, version: 10.0.15063.674, time stamp: 0x8ac9f9d4
            Exception code: 0xc0000409
            Fault offset: 0x000000000007350e
            Faulting process id: 0x26fc
            Faulting application start time: 0x01d398c7e6228539
            Faulting application path: C:\Program Files\Devart\dbForge Studio Express for MySQL\dbforgemysql.exe
            Faulting module path: C:\WINDOWS\System32\ucrtbase.dll
            Report Id: dc61c8e8-1ed4-44d0-8ac0-57011fb3f67a
            Faulting package full name:
            Faulting package-relative application ID:

            2 votes
            Vote
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              Password icon
              I agree to the terms of service
              Signed in as (Sign out)
              You have left! (?) (thinking…)
              2 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →

              Could you please turn on dump generating as described below and send it to us for investigation?

              1. Start Regedit.exe
              2. Create a registry key:
              “HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\Windows Error Reporting\LocalDumps\dbforgemysql.exe”
              3. Add the following values into it:
              “DumpFolder”=“С:\\DbForgeDumpFolder”
              “DumpType”=dword:00000002
              “CustomDumpFlags”=dword:00001124
              4. After the application crashes, send us the content of the folder “DbForgeDumpFolder”.

              You can send a reply straight to our support system at alexaATdevartDOTcom and supportATdevartDOTcom .

            • it cannot be brought to the foreground

              the latest version 7.3.137 once minimized or hiden by another program, after some time it cannot be brought to the foreground. And if you try to close it from the task bar, pops up a box to save any unsaved objects, but there is way to click on the buttons, it like something else is grabbing the input. In that state I saves a process dump. Please let me know how can I uploaded it to you.

              1 vote
              Vote
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                Password icon
                I agree to the terms of service
                Signed in as (Sign out)
                You have left! (?) (thinking…)
                0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
              • bugfix

                After a few hours open, either maximized or minimized, it gets frozen, I cannot click in any button. It is like if an invisible modal button is blocking the input. This is the latest version 7.3.131. please let me know how can I help you find the issue

                1 vote
                Vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  I agree to the terms of service
                  Signed in as (Sign out)
                  You have left! (?) (thinking…)
                  1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                • 0 votes
                  Vote
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    Password icon
                    I agree to the terms of service
                    Signed in as (Sign out)
                    You have left! (?) (thinking…)
                    0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                  • Error reports with no email client

                    Few people still use email clientes in their laptops these days. I frequently see errors in dbForge Studio, I frequently find errors on the new 7.3 version, but I cannot send them.

                    It's 2018, please create an API to receive these errors without requiring email clients.

                    1 vote
                    Vote
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      Password icon
                      I agree to the terms of service
                      Signed in as (Sign out)
                      You have left! (?) (thinking…)
                      0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                    • Configure SECURITY DEFINER

                      Have an option to be able to configure the default SECURITY DEFINER, currently it always selects Definer and the current user. I want to be able to configure a different user or for it to be SECURITY INVOKER.

                      3 votes
                      Vote
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        Password icon
                        I agree to the terms of service
                        Signed in as (Sign out)
                        You have left! (?) (thinking…)
                        0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                      • Add schema name to qualify table in intellisense

                        I love your intellisense but....
                        if you are working on a query in a different schema that the join you are making the schema name is to inserted.

                        for example let say you have scha.table1, schb.table2, schb.table3 with and FK defintion between the latter 2 tables

                        if you are in scha and start typing

                        select *
                        from schb.table2
                        inner join

                        intellisense wil propose the join with table3 (great) but if you select it it just insert
                        inner join table3 on .....
                        instead on schb,table3 on .....

                        1 vote
                        Vote
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          Password icon
                          I agree to the terms of service
                          Signed in as (Sign out)
                          You have left! (?) (thinking…)
                          0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                        • procedure combined layout shortcut

                          Hello

                          I need combined layout shortcut for editing procedure or function.

                          Always, I click split or combined button.

                          It's very inconvenience.

                          1 vote
                          Vote
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            Password icon
                            I agree to the terms of service
                            Signed in as (Sign out)
                            You have left! (?) (thinking…)
                            0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                          • NEXT AND PRIOR SQL

                            in the previous version there was the option to navigate within the same document between the commands executed next / previous ... I noticed that in the new version 7.3 no longer exists this command. My suggestion since I see that there is no longer this possibility and it is impossible to access the history in another tab copying and pasting I would like to know if it would have the possibility since it has all the recorded history (and it was good) to have a command or key that navigate to history by copying the command automatically to the…

                            1 vote
                            Vote
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              Password icon
                              I agree to the terms of service
                              Signed in as (Sign out)
                              You have left! (?) (thinking…)
                              0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                            • Search text in trigger statement

                              The text search in trigger statements doesn't work using the "Find box" with "Look in -> Current Document".

                              Can you please solve this problem?

                              Thank you very much for your great work!

                              Francesco

                              1 vote
                              Vote
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                I agree to the terms of service
                                Signed in as (Sign out)
                                You have left! (?) (thinking…)
                                0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                              • JSON import to handle relational json data objects

                                JSON can store complex and dynamic relational data structures. It self describes the data structure, but when you want to import that into a relational database, you need to create the tables and capture the relationships using primary and foreign keys. A smart import which could create the tables and keys on the fly would be invaluable

                                1 vote
                                Vote
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  I agree to the terms of service
                                  Signed in as (Sign out)
                                  You have left! (?) (thinking…)
                                  0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                • 3 votes
                                  Vote
                                  Sign in
                                  Check!
                                  (thinking…)
                                  Reset
                                  or sign in with
                                  • facebook
                                  • google
                                    Password icon
                                    I agree to the terms of service
                                    Signed in as (Sign out)
                                    You have left! (?) (thinking…)
                                    0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                  • New function

                                    it is necessary to add a great feature: if there is a connection to several databases that would click on any of the objects, this database became active and the request addressed to the active database, with active database would be highlighted, and the passive was less bright. this function is for heidisql.

                                    1 vote
                                    Vote
                                    Sign in
                                    Check!
                                    (thinking…)
                                    Reset
                                    or sign in with
                                    • facebook
                                    • google
                                      Password icon
                                      I agree to the terms of service
                                      Signed in as (Sign out)
                                      You have left! (?) (thinking…)
                                      0 comments  ·  Flag idea as inappropriate…  ·  Admin →
                                    • Can't follow Caret when input Chinese characters

                                      When using Chinese PinYin input(such as QQ pinyin input), the input box will keep at the left-top screen, don't follow my cursor position.

                                      1 vote
                                      Vote
                                      Sign in
                                      Check!
                                      (thinking…)
                                      Reset
                                      or sign in with
                                      • facebook
                                      • google
                                        Password icon
                                        I agree to the terms of service
                                        Signed in as (Sign out)
                                        You have left! (?) (thinking…)
                                        0 comments  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                      • Handle newline and carriage return in result data

                                        When results from SQL query contain a newline/carriage return, only the first part of the result (until the first CR) is displayed.

                                        For instance, if my DB field contains CR as follows :
                                        My Business
                                        1 park avenue
                                        New-York
                                        USA

                                        When getting this field content through select, only the first line ("My Business") is displayed in the result panel.

                                        1 vote
                                        Vote
                                        Sign in
                                        Check!
                                        (thinking…)
                                        Reset
                                        or sign in with
                                        • facebook
                                        • google
                                          Password icon
                                          I agree to the terms of service
                                          Signed in as (Sign out)
                                          You have left! (?) (thinking…)
                                          1 comment  ·  Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                                        • alter table sql needed when i edit table in GUI

                                          when i alter any column for renaming or chaning data type or any other action in table using GUI, I want it also as SQL code like in xampp

                                          1 vote
                                          Vote
                                          Sign in
                                          Check!
                                          (thinking…)
                                          Reset
                                          or sign in with
                                          • facebook
                                          • google
                                            Password icon
                                            I agree to the terms of service
                                            Signed in as (Sign out)
                                            You have left! (?) (thinking…)
                                            0 comments  ·  Features  ·  Flag idea as inappropriate…  ·  Admin →
                                          ← Previous 1 3 4 5 18 19
                                          • Don't see your idea?

                                          dbForge Studio for MySQL

                                          Feedback and Knowledge Base