'How to create mysql data with specific CSV file strings
I have csv file which has data as in following format(data has converted from rrd to csv)
.....
......
<database>
<!-- 2022-04-26 22:04:00 +0530 / 1650990840 --> <row><v>5.0000000000e+00</v></row>
<!-- 2022-04-26 22:05:00 +0530 / 1650990900 --> <row><v>5.0000000000e+00</v></row>
<!-- 2022-04-26 22:06:00 +0530 / 1650990960 --> <row><v>5.0000000000e+00</v></row>
</database>
....
.....
Are there any method to extract 2022-04-26 22:04:00 +0530 as the date,1650990840 as num1, 5.0000000000e+00 as num2?
Final output should be as follows,
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|

