What does –i-am-a-dummy flag to do when starting

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What does –i-am-a-dummy flag to do when starting MySQL?

Makes the MySQL engine refuse UPDATE and DELETE commands where the WHERE clause is not present.

(Continued on next question...)

Other Job Interview Questions

• When you create a table, and then run SHOW CREATE TABLE on it, you occasionally get different results than what you typed in. What does MySQL modify in your newly created tables?
• MySQL - Setting Up Passwords
• MySQL - Using Symbolic Links for Databases and Tables
• How to get Maximum Performance from MySQL
• How do you return the a hundred books starting from 25th?
• How would you change a column from VARCHAR(10) to VARCHAR(50)?
• MySQL - Using Your Own Benchmarks
• If the value in the column is repeatable, how do you find out the unique values?
• Adding New User Privileges to MySQL
• MySQL - Keeping Your Password Secure
• More...