I don’t know if you have configured the console output and the configuration of the sql statement issued. If you have configured it, you can check whether there is any problem with the sql statement issued
If an error occurs, an exception should be thrown. If the update number is 0, it can only mean that no data has been updated. Generally speaking, there are two reasons: one is that the data to be updated is not found according to the WHERE condition; the other reason is that it is found, but the new data and the data stored in the database are different. the same.
When running, the console will output the actual SQL during execution. Check carefully to see if there are any problems, or copy it to DBMS for execution
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
I don’t know if you have configured the console output and the configuration of the sql statement issued. If you have configured it, you can check whether there is any problem with the sql statement issued
If an error occurs, an exception should be thrown. If the update number is 0, it can only mean that no data has been updated. Generally speaking, there are two reasons: one is that the data to be updated is not found according to the WHERE condition; the other reason is that it is found, but the new data and the data stored in the database are different. the same.
I am also very good, maybe you can write out the type resultType returned by update
When running, the console will output the actual SQL during execution. Check carefully to see if there are any problems, or copy it to DBMS for execution
If there is no exception, it means that the update where condition is not established and there is no record that meets the update condition