All pastes #792517 Raw Edit

Stuff

public text v1 · immutable
·published 2007-11-21 14:18 UTC
rendered paste body
+----------------+------+----------+
| id             | cod  | num      |
+----------------+------+----------+
| 00985187000120 | 0048 | 33356555 |
| 00984040000115 | 0061 | 36292928 |
| 00925776000129 | 0011 | 36390300 |
| 00925776000129 | 0011 | 36390303 |
+----------------+------+----------+

I want to convert this into something like:

+----------------+------+----------+------+----------+
| id             | cod1 | num1     | cod2 | tel2     |
+----------------+------+----------+------+----------+
| 00985187000120 | 0048 | 33356555 | NULL | NULL     |
| 00984040000115 | 0061 | 36292928 | NULL | NULL     |
| 00925776000129 | 0011 | 36390300 | 0011 | 36390303 |
+----------------+------+----------+------+----------+