Error while writing data to mysql
Error 1: Data truncated for column 'root_rank' at row 22
user_name VARCHAR(10)is defined, this field defines the maximum length of
10characters. However, if the data you write exceeds
10characters, then this warning message will appear.
cost DECIMAL(10,2)is defined, this field allows two decimals. However, if the data you write exceeds two decimal places, such as
10.1122, this warning message will appear.
For specific problems, you can adjust the field type of the database table, or check whether the inserted data does not meet expectations.