Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Selected Reading
What MySQL INSERT() function returns if the number of characters to be removed exceeds the number of characters available in original string?
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) Advertisements
