Skip to content
Fix Code Error

MySQL error code: 1175 during UPDATE in MySQL Workbench

March 13, 2021 by Code Error
Posted By: Anonymous

I’m trying to update the column visited to give it the value 1. I use MySQL workbench, and I’m writing the statement in the SQL editor from inside the workbench. I’m writing the following command:

UPDATE tablename SET columnname=1;

It gives me the following error:

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
….

I followed the instructions, and I unchecked the safe update option from the Edit menu then Preferences then SQL Editor. The same error still appear & I’m not able to update this value. Please, tell me what is wrong?

Solution

I found the answer. The problem was that I have to precede the table name with the schema name. i.e, the command should be:

UPDATE schemaname.tablename SET columnname=1;

Thanks all.

Answered By: Anonymous

Related Articles

  • Form field border-radius is not working only on the last…
  • Trouble with boxes appearing/hiding based on selection
  • React Multi-level push menu SCSS Back button not working
  • How do I get the SharedPreferences from a PreferenceActivity…
  • How to remove MySQL completely with config and library…
  • Eclipse fails to open .vue files in Web Page Editor
  • Generating a drop down list of timezones with PHP
  • Eclipse will not start and I haven't changed anything
  • JS Graph recursive vs iterative DFS order difference
  • Search for one value in any column of any table inside a…

Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.

Post navigation

Previous Post:

How to get the children of the $(this) selector?

Next Post:

Difference between del, remove, and pop on lists

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

  • Get code errors & solutions at akashmittal.com
© 2022 Fix Code Error