Detailed analysis of the syntax of Mysql update to modify multiple fields and

When updating a record in MySQL, the syntax is correct, but the record is not updated...

Question Statement

The record before execution is as follows:

The record after execution is as follows:

As you can see, it actually works:

why?

It seems that there is no problem with the syntax. The update syntax of the MySQL official document is:

Seeing that the format of assignment_list is a comma-separated list of col_name=value , it suddenly became clear that the multi-field update statement that the developer wanted should be written like this:

Summary: In an UPDATE statement, if you want to update multiple fields, you cannot use "AND" between the fields, but should separate them with commas.

Principle: Why does the strange result of owner_code=0 appear when "AND" is used to separate? After many attempts, I found that:

And ('43212' and owner_name='李四') is a logical expression, and it is not difficult to know here that owner_name is not '李四'. Therefore, the result of this logical expression is false, which is equivalent to 0 in MySQL!

This is the end of this article about the syntax of mysql update to modify multiple fields and. For more relevant mysql update to modify field and syntax content, please search 123WORDPRESS.COM's previous articles or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!