A mysql test question about update I went to the interview some time ago and saw a test Question: The TABLE creation statement is: CREATE table · test _ TABLE '{id int (5) unsigned NOT NULL AUTO_INCREMENT, a int (1) not null, B int (1) not null default 1) ENGINE = INNODB; then add data in the table insert into test_table SET a = 0, B = 1; insert into test_table SET a = 1, B = 2; insert into test_table SET a = 2, B = 3; insert into test_table SET a = 3, B = 4; UPDATE test_table SET a = 1 AND B = 1 is the result of the database after the following statement is executed. during development, UPDATE TABLE SET A = 1 is always used, B = 1 WHERE id = 1 and so on, I have never touched on the previous questions. Later I found through the thinking AND query manual that the column UPDATE of the UPDATE statement can be related to the expression AND then convert the statement into UPDATE test_table SET a = (1 AND B = 1) then we can analyze the four inserted statements. The first one is a = 0 B = 1. The expression analysis condition is true, and the second, third, and fourth condition expressions are false. the result is idab111202303404.