Shulou(Shulou.com)06/02 Report--

Many novices are not very clear about the anomalies of Mysql encountered when running batch testing. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can get something.

The latest running batch

(1) You can't specify target table 'NPLM_LOAN_CONTRACT' for update in FROM clause

When deleting or updating, you cannot check your own conditions in the where condition (you cannot select some values in the same table first, and then update this table (in the same sentence), that is, you cannot update the value of a field based on the value of a field. As shown in the figure, you should give the subquery an extra layer.

(2) '137' in column'6'is outside valid range for the datatype TINYINT.

When querying, the type length of the field is limited. My field is of byte type, and the value found should exceed the length of this byte. (my main purpose is to change the byte of the field in the entity to int type, so the error is reported.

Refer to this podcast to solve the problem: https://www.cnblogs.com/qingqing-919/p/9414711.html

(3) nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'OVERDUE_DAYS' at row 1

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.