top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What does " i_am_a_dummy flag" do in MySQL?

0 votes
807 views
What does " i_am_a_dummy flag" do in MySQL?
posted Mar 13, 2017 by Navya

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

The " i_am_a_dummy flag" enables MySQL engine to refuse any UPDATE or DELETE statement to execute if the WHERE clause is not present.

mysql --i-am-a-dummy -uroot test

Example

mysql> DELETE FROM bigtable;
ERROR 1175: You are using safe update mode and you
tried to update a table without a WHERE that uses a 
KEY column
answer Mar 14, 2017 by Arun Angadi
...