1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

In mysql workbench Debugging query I do not see result rows

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

  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?
    SEMrush
    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
    SEMrush
  2. sarahk

    sarahk iTamer Staff

    Messages:
    25,165
    Likes Received:
    3,427
    Best Answers:
    100
    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 Active Member

    Messages:
    68
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    61
    #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