Resolved: Getting error code 1140 even after trying the fixes.
Still gtting error code 1140 even after applying the fixes from another persons question. I made sure to restart MySQL after each fix. Any help?
Hi Donald!
Thanks for reaching out!
Please, remove the concat() method. Actually, you first remove this mode and then you add it. You have to run only:
set @@global.sql_mode := replace(@@global.sql_mode, 'ONLY_FULL_GROUP_BY', '');
and then restart the Workbench.
Hope this helps.
Best,
Tsvetelin
Ok that worked Thanks!
You are very welcome!
Kind regards,
Martin,
The 365 Team
I am just running the replace method, but still am getting the same error. Could you help me out and at same time eplxain what is this replace and contact method?
Hi Saeed!
Thanks for reaching out.
These are methods. The REPLACE()
method replaces all occurrences of a substring within a string, with a new substring. The CONCAT()
method adds two or more strings together. In order to resolve the issue, you should restart the Workbench or reconnect to the server.
Hope this helps.
Best,
Tsvetelin