Mysql generates implicit conversions when manipulating different types of parameters. Among them, when a string needs to be converted into a floating-point number, mysql starts to convert the string from the left, and the conversion rules are as follows: