In the function INSERT(str, Pos, len, newstr), what will be the result if len is not within the length of the rest of the string?

If 'len' is not within the length of the rest of the string, the MySQL INSERT() function will continue to remove characters until the end of the string is original String.

Example

mysql> Select INSERT('myteststring',3,15,'name');
+------------------------------------+
| INSERT('myteststring',3,15,'name') |
+------------------------------------+
| myname                             |
+------------------------------------+
1 row in set (0.00 sec)

The above is the detailed content of In the function INSERT(str, Pos, len, newstr), what will be the result if len is not within the length of the rest of the string?. For more information, please follow other related articles on the PHP Chinese website!