What MySQL INSERT() function returns if the number of characters to be removed exceeds the number of characters available in original string?

MySQLMySQLi Database

In case if the number of characters to be removed exceeds the number of characters available in original string then MySQL INSERT() function will continue to remove the characters until the end of the original string.

Example

mysql> Select INSERT('myteststring',3,15,'original');

+----------------------------------------+
| INSERT('myteststring',3,15,'original') |
+----------------------------------------+
| myoriginal                             |
+----------------------------------------+

1 row in set (0.00 sec)
raja
Published on 20-Feb-2018 08:23:42
Advertisements