2

Normally i can update my rows w/ queries such as

UPDATE t SET col1='123' WHERE col2 LIKE '%abc%';

or

UPDATE mydb.t SET col1='123' WHERE col2 LIKE '%abc%';

But with MySQL Workbench I seem to only be able to SELECT but cannot UPDATE the tables with queries.

Does anyone know a fix for working with workbench?

FIX

To disable safe mode, toggle the option in Preferences -> SQL Editor -> Query Editor and reconnect.

Kermit
  • 33,827
  • 13
  • 85
  • 121
t q
  • 4,593
  • 8
  • 56
  • 91

1 Answers1

0

Mysql workbench usually disables by default updates without a where clause, and/or updates that hit more than a configured X elements.

When you try to update and fail, if it is how I think it is, then pay attention to the error message, as it tells you exactly which setting to change.

Andrei
  • 1,613
  • 3
  • 16
  • 36
  • You can find the error details and answer here: http://stackoverflow.com/questions/14231278/error-error-code-1175-during-executing-update-command-on-table-using-mysql-wo – Ripon Al Wasim Jan 09 '13 at 09:24