Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How can I solve these line errors on MySQL Workbench?

Tags:

mysql

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
Sign in to Comment

Related questions

mysql_install_db giving error
MySQL 5.6 deadlock for locking the same rows twice?
phpmyadmin run mysql stored procedure but no output
Laravel hasManyThrough but must return only one array
Mysql Query Group Concat Limit multiple record of child table in single query
How to connect to mysql running on docker using Sequel Pro
How to enter arguments of celery jobs into database to be queried; using mysql
PHP PDO in Exception Mode - Still need to check return of execute function (and others)?
AWS Lambda RDS too many connections
Using MATCH with OR returns results that satisfy none of the conditions
How can I make PHP scripts timeout gracefully while waiting for long-running MySQL queries?
MySQL Display Table Name Along With Columns
What authentication libraries for PHP are not attached to a framework and meet these requirements?
How to make a Wilson score interval that decreases by time
phpmyadmin cannot Export procedure
Copy autoincrement value to another column on insert?
Memory leak with large dataset when using mysql-python
How to remotely connect to ClearDB in an Azure Website?
Newly added column not visible in phpMyAdmin
MySQL query to get a travel route

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!