Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How can I solve these line errors on MySQL Workbench?

As you can see, there's no syntax error or something like that on my code. Can you guys help me?

Here an example...

like image 461
flpn Avatar asked Jun 30 '16 14:06

flpn


People also ask

How do I see errors in MySQL Workbench?

To cause MySQL Workbench to show error messages, I had to change a preference. From the Workbench menu, click "Edit" -> "Preferences..." Open the "SQL Queries" tab. Check "Confirm Data Changes".

How do I find line breaks in MySQL?

-- insert some sample data(3,'Robert\r\n'), (4, 'This is \n test'); Below query will return all the values which has \n or \r or both of them.

How do you check line errors in SQL?

mysql_errno() returns the MySQL error code. mysql_sqlstate() returns the SQLSTATE value. mysql_error() returns the message string.


1 Answers

I guess this is just a little bug in the error markup machinery. Try editing the code or close this editor and open a new one. If you have a list of steps to reproduce this you could even create a bug report, so that gets fixed.

like image 138
Mike Lischke Avatar answered Oct 19 '22 05:10

Mike Lischke