Hello everyone, I need your help.
I’ve this mysql table:
+------------+-------------+------+---------------------+------------------+
| Node | Description | Zone | XXXXTEL | Date_Resolution |
+------------+-------------+------+---------------------+------------------+
| KR10240497 | @TERMX | KR1O | 998482933-980867854 | 2009-10-12 |
| KR10240497 | @TERMX | KR1O | 998482933-980867854 | 0000-00-00 |
| KR10227386 | C.B.S.M. | KR1M | 999073514-981512863 | 2008-11-13 |
| KP60203932 | GNRT | MO6O | T00000352-803521891 | 2012-06-19 |
| KP60210819 | NAPOLBANKO | MO6N | T00012472-T00012450 | 2010-04-27 |
+------------+-------------+------+---------------------+------------------+
5 rows in set
I need split value of column ‘XXXXTEL’ and create and insert in this table new row with the second value splitted in column ‘XXXXTEL’.
I need this output, can you help me?
+------------+-------------+------+---------------------+------------------+
| Node | Description | Zone | XXXXTEL | Date_Resolution |
+------------+-------------+------+---------------------+------------------+
| KR10240497 | @TERMX | KR1O | 998482933 | 2009-10-12 |
| KR10240497 | @TERMX | KR1O | 980867854 | 2009-10-12 |
| KR10240497 | @TERMX | KR1O | 998482933 | 0000-00-00 |
| KR10240497 | @TERMX | KR1O | 980867854 | 0000-00-00 |
| KR10227386 | C.B.S.M. | KR1M | 999073514 | 2008-11-13 |
| KR10227386 | C.B.S.M. | KR1M | 981512863 | 2008-11-13 |
| KP60203932 | GNRT | MO6O | T00000352 | 2012-06-19 |
| KP60203932 | GNRT | MO6O | 803521891 | 2012-06-19 |
| KP60210819 | NAPOLBANKO | MO6N | T00012472 | 2010-04-27 |
| KP60210819 | NAPOLBANKO | MO6N | T00012450 | 2010-04-27 |
+------------+-------------+------+---------------------+------------------+