INSERT('ABCDEFG', 3, 100, 'ZZZ'); : INSERT « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. INSERT
mysql>
mysql>
mysql> SELECT INSERT('ABCDEFG', 3, 100, 'ZZZ');
+----------------------------------+
| INSERT('ABCDEFG', 3, 100, 'ZZZ') |
+----------------------------------+
| ABZZZ                            |
+----------------------------------+
1 row in set (0.00 sec)

mysql>








23.16.INSERT
23.16.1.INSERT(str,pos,len,newstr): Replaces the string str with the substring beginning at position pos and len characters long replaced by the string newstr
23.16.2.INSERT('ABCDEFG', -1, 4, 'ZZZ');
23.16.3.INSERT('ABCDEFG', 3, 100, 'ZZZ');
23.16.4.Use Insert function to insert text to the first_name