It looks like your MySql session has the safe-updates option set. This means that you can’t update or delete records without specifying a key (ex. primary key
) in the where clause.
Try:
SET SQL_SAFE_UPDATES = 0;
Or you can modify your query to follow the rule (use primary key
in where clause
).
Related Contents:
- MySQL: How to allow remote connection to mysql
- Error Code: 2013. Lost connection to MySQL server during query
- mysql update column with value from another table
- How do I enlarge an EER Diagram in MySQL Workbench?
- Create a new database with MySQL Workbench
- String concatenation in MySQL
- UPDATE multiple rows with different values in one query in MySQL
- How to get ER model of database from server with Workbench
- Is there a naming convention for MySQL?
- UPDATE multiple tables in MySQL using LEFT JOIN
- How to update column with null value
- How do I retrieve my MySQL username and password?
- Change One Cell’s Data in mysql
- MySQL, update multiple tables with one query
- How to prepend a string to a column value in MySQL?
- Cannot connect to Database server (mysql workbench)
- How to take MySQL database backup using MySQL Workbench?
- How to connect mysql workbench to running mysql inside docker?
- How to view table contents in Mysql Workbench GUI?
- MySQL Workbench Edit Table Data is read only
- mysql update multiple columns with same now()
- How to get a table creation script in MySQL Workbench?
- How can I directly view blobs in MySQL Workbench
- MySQL: update a field only if condition is met
- MySQL Workbench not displaying query results
- MySQL Workbench auto increment disabled
- How to generate the whole database script in MySQL Workbench?
- Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003) [closed]
- MySql workbench query history ( last executed query / queries ) i.e. create / alter table, select, insert update queries
- How to unblock with mysqladmin flush hosts
- Moving connections and instances between two computers
- MySQL update table based on another tables value
- MySQL Workbench: how do I set up “ON UPDATE” and CURRENT_TIMESTAMP?
- Bulk update mysql with where statement
- mysql workbench error opening EER
- Can’t export my database from mysql workbench
- Using mysqldump to format one insert per line?
- Generate ER Diagram from existing MySQL database, created for CakePHP [closed]
- MySQL update a joined table
- Execute statement by shortcut in MySQLWorkbench
- Insert the same fixed value into multiple rows
- Update MySQL with if condition
- Customizing Keyboard Shortcuts in MySql Workbench
- How do I generate a SQL script from my diagram in MySQL Workbench?
- Update values incrementally in mysql
- MySQL – How do I enter NULL?
- How can I import data into mysql database via mysql workbench?
- When running UPDATE … datetime = NOW(); will all rows updated have the same date/time?
- How do I disable the SSL requirement in MySQL Workbench?
- MySQL Workbench cannot load mysql.proc