StackOverflowNewbie
StackOverflowNewbie

Reputation: 40653

MySQL Workbench: how to display warnings?

When I run a particular query, I get a message: "Your query produced 1 warnings." I'd like to know exactly what the warning was about. How do I view the warning's details? I'm on Windows using Workbench version 7.

Upvotes: 2

Views: 7066

Answers (5)

user3794200
user3794200

Reputation:

You can go to (Help -> Show Log File) and it will display the warning message.

Upvotes: 1

Ankita.P
Ankita.P

Reputation: 442

show warnings 

should work for more description

Upvotes: 1

Nadine
Nadine

Reputation: 1638

These 2 solutions worked for me on Workbench 6.0 on Linux, maybe one of them will work for you:

  • Hover over the warning message with your mouse. Or hover over the previous message (if there are any previous messages)
  • Otherwise, in the same query tab, write any other query and execute it. For some reason, the old warning message expands once I do that. It seems there's a bug with the last message in the list.

Upvotes: 0

Puneet Purohit
Puneet Purohit

Reputation: 1291

checkout this link. It will tell you about the workbench windows.

http://dev.mysql.com/doc/workbench/en/wb-sql-editor-query-panel.html

Pl - use hide/show panel to activate different windows.

Upvotes: -1

Mike Lischke
Mike Lischke

Reputation: 53532

Do you see the Action Output pane in the lower part of the SQL IDE? All queries that you send appear there and any warning or error message will too. In the toolbar at the top, in the far right corner there are 3 buttons to switch specific parts of Worbench. The middle one is for the output area. See that this is activated to have the pane actually on screen.

Upvotes: 2

Related Questions