Home > Database > Mysql Tutorial > 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?

王林
Release: 2023-09-05 23:21:02
forward
1413 people have browsed it

如果要删除的字符数超过原始字符串中可用的字符数,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)
Copy after login

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!

source:tutorialspoint.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template