Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
593 views
in Technique[技术] by (71.8m points)

MySQL WORKBENCH 8 not showing error message on UBUNTU 20.04.1

I have committed a mistake in order to show you my problem.

Workbench isn't able to compile this query as it has an error in the SELECT statement. I use a different abbreviation from the one that's been already defined.

Normally when getting an error, Workbench gives you a clue of where you can find the mistake in a window that at the bottom.

My Workbench has not this window. Then, cannot solve the mistake...

ANY HELP FOR GETTING THIS WINDOW?

Workbench

question from:https://stackoverflow.com/questions/65899384/mysql-workbench-8-not-showing-error-message-on-ubuntu-20-04-1

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

The shown query is syntactically correct. That's why you don't see an error marker from the syntax checker. However, it might be wrong from a data standpoint (e.g. table empresa doesn't exist or the DEPT column has a different name etc.).

You can see the response from the server when you execute the query by opening the output pane using the marked button in the toolbar:

enter image description here


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...