Home  >  Article  >  Database  >  What does the MySQL INSERT() function return if the number of characters to be deleted exceeds the number of characters available in the original string?

What does the MySQL INSERT() function return if the number of characters to be deleted exceeds the number of characters available in the original string?

王林
王林forward
2023-09-05 23:21:021379browse

如果要删除的字符数超过原始字符串中可用的字符数,MySQL INSERT() 函数会返回什么?

If the number of characters to be deleted exceeds the number of characters available in the original string, the MySQL INSERT() function will continue to delete 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)

The above is the detailed content of What does the MySQL INSERT() function return if the number of characters to be deleted exceeds the number of characters available in the original string?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete