Reputation: 849
When I execute sql statements with errors, mySQL is not telling me if I have an syntax error or any other kind of error, neither shows me if the statement was executed sucessfully.
I trying to execute statements without the wizard's workbench, I mean, I writing directly the statements.
For example, if I execute this:
insert into PROFF(aVARCHAR) values ('aVARCHAR')
it shows nothing.
If i execute the correct query without the single quotes mistake:
insert into PROFF(aVARCHAR) values (`aVARCHAR`)
it shows nothing neither.
Is there something I need to set up in order to see the error messages?
Upvotes: 3
Views: 7095
Reputation: 849
The bottom panel was hidden. That's why I couldn't see any error messages.
Upvotes: 21
Reputation: 4581
Just a quick sanity check, you are typing a semi-colon (";") after you enter the statement, right? It won't run a statement given via the mysql command-line client until you do.
Upvotes: 0