How to update data using MariaDB console

Frappe Framework
,
1

I want to update data using mariadb console without providing key column how to do it

image
image1586×728 204 KB

Thank you

2

If you google that phrase underlined in green, you will quickly find the answers.

I did exactly that the other day but forgot the details so can’t post it here correctly just like that; anyway, it’s some setting in MariaDB which helps people not to shoot themselves in the foot with unintentioned mass deletes/changes.

1 Like
3

@Peer

SET SQL_SAFE_UPDATES = 0;

Right