I ran the mysql_data_4.sql installation script from MySQL workbench to populate the default data and got the following error.

23:39:45 TRUNCATE TABLE profiles_types Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor -> Query Editor and reconnect. 0.000 sec

What should I do?

asked 09 Mar '13, 00:44

janice's gravatar image

accept rate: 0%

since this is workbench related warning/error, do what it recommends.. Workbench runs in safe mode out-of-the-box..

to disable it... Preferences -> SQL Editor -> Query Editor. look for the correct preference and uncheck it.

you need to restart workbench


answered 11 Mar '13, 22:09

anjan's gravatar image

anjan ♦♦
accept rate: 22%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 09 Mar '13, 00:44

Seen: 4,423 times

Last updated: 11 Mar '13, 22:09