In mysql workbench Debugging query I do not see result rows

Discussion in 'MySQL' started by mstdmstd, Aug 23, 2019.

0
  1. #1
    Hello,
    With mysql workbench 6.3 under ubuntu 18 when I want to debug some sql I click “Create a new sql tab for executing queries” toolbar item
    and new tab editor is opened. When I click “Execute the selected portion...” toolbar item I see info on the sql executed,
    but not result rows, as I expected : https://imgur.com/a/wnRKTUO.
    1) Is it some hidden area?

    2) I do not want to use all my databases on this connection, How can I hide some databases, without deleting them?

    Thanks!
     
    mstdmstd, Aug 23, 2019 IP
  2. sarahk

    sarahk iTamer Staff

    Messages:
    28,777
    Likes Received:
    4,524
    Best Answers:
    123
    Trophy Points:
    665
    #2
    You get an error message

    upload_2019-8-24_17-2-13.png
    You need to select a database before you run your query.

    I'm not sure how you hide the ones you don't want to use, but they're listed, not active.
     
    sarahk, Aug 23, 2019 IP
  3. mstdmstd

    mstdmstd Well-Known Member

    Messages:
    130
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    123
    #3
    Thank you for your hint!
    I found that I need to select the db AS DEFAULT DATABASE to sent all request to this database.
    No ideas as for point 2) ?
     
    mstdmstd, Aug 24, 2019 IP