CopyPastor

Detecting plagiarism made easy.

Score: 0.8037826022365062; Reported for: String similarity Open both answers

Possible Plagiarism

Plagiarized on 2023-04-01
by Ishan Anand

Original Post

Original - Posted on 2012-07-12
by Habibillah



            
Present in both answers; Present only in the new answer; Present only in the old answer;

It seems like your MySql session has the [safe-updates][1] option set. This means it can't update or delete records without specifying a key (ex. `primary key`) in the `where` clause. If you don't want to specify the key in the `where` clause then executes the below code first and then try executing your query.
`SET SQL_SAFE_UPDATES = 0;`

[1]: https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html#option_mysql_safe-updates
It looks like your MySql session has the [safe-updates option][1] 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`).

[1]: http://dev.mysql.com/doc/refman/5.5/en/mysql-command-options.html#option_mysql_safe-updates

        
Present in both answers; Present only in the new answer; Present only in the old answer;