Skip to content
← Customer Feedback for Devart

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/

dbForge Studio for MySQL

Categories

JUMP TO ANOTHER FORUM

(thinking…)

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.

71 results found

  1. Can't login to forum, goes around in circles

    I don't know my username, I know my email, I can't request my password as it says my account is activated, but I can't get the activation email because I don't know the username apparently.

    Someone help, very frustrating

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  2. CLIENT_INTERACTIVE flag in mysql_real_connect

    How about an option in the connection string to mark the connection as an interactive one so that interactivetimeout applies instead of waittimeout?

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  3. 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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  4. 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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  5. 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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  6. 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

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  7. Be able to close connection from the stored procedure editor

    Not sure if it needs to be classified as a bug or a new features BUT!!!!
    I noticed today after our Aurora AWS Cluster failed over that I was not able to recompile a stored procedure I was altering.
    From a query window you can close the connection and an execute will open it again.
    But you can't close the connection from the editor!!
    And it's the same with Table Editor.
    I know you can close it from the DB Explore but it's inconsistent with the SQL Editor UI. You should have the same buttons.

    1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  8. Fix Stored Procedure Editor to accept ALTER TABLE xxx RENAME TO yyy

    As of dbForge for MySQL version 8.0.40, the Stored Procedure Editor (and Schema Compare) have started to throw errors when trying to open one of our stored procedures. I have traced it down to the presence of an ALTER TABLE command within the procedure.

    Here is a simple procedure that will trigger the error:

    DELIMITER $$

    DROP PROCEDURE IF EXISTS sp_test$$

    CREATE DEFINER=root@localhost PROCEDURE sp_test()
    MODIFIES SQL DATA
    BEGIN

    ALTER TABLE foo RENAME TO bar;

    END
    $$

    DELIMITER ;

    Specifically, if you try to open the procedure in the procedure editor, dbForge will display the error…

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    AdminDevart (_, Devart) responded

    Could you please provide us the following information:
    1. Server version.
    2. Result of the following query:
    SHOW CREATE PROCEDURE sp_test;

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

  9. Find Invalide Objects

    == English ==
    The "Find Invalid Objects" wizard lists the following objects in the new version "dbForge Studio for MySQL 9.0.338":

    • Temporary tables are listed in Views as not being found
      In Vden Views, the temporary tables are e.g. created with the following command:
      WITH RECURSIVE TMP as Select .... from ...) Select ... from TMP

    • crdebug.ENTERMODULE2 is not found. It is searched in the respective database; but not in the cr_debug database.

    • crdebug.ENTERHANDLER is not found. It is searched in the respective database; but not in the cr_debug database.

    • No further objects from the cr…

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  10. scroll 'wheels' do not work

    Whether used on my laptop with a touchpad or my desktop with a mouse, dbForge Studio doesn't support scrolling in any window by any means other than clicking or dragging the scroll bar. It will initially scroll for perhaps a second and then it stops.

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    3 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

  11. view with a UDF calling an aggregate function adds quotes around the aggregate

    I'm creating a view using the valid SQL:

    SELECT dateAsString(MAX(a.dateStart)) AS LastDate ...

    dateAsString is a UDF in my database that accepts a DATE parameter.

    The query executes fine. When I save it in a view, though, dbForge changes the query text to:

    dateAsString(MAX(a.dateStart))

    Which, obviously, won't work.

    Any thoughts?

    0 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    AdminDevart (_, Devart) responded

    Could you please provide us the following information:
    1. Version of the MySQL server.
    2. CREATE definition of the UDF.
    3. The assembly file containing the functions called by the UDF.

1 2 4 Next →
  • Don't see your idea?