0

I am migrating a DB from Mongo to MySQL the mongo DB has a column contains mobile numbers that is an array of numbers I have exported the data in a CSV file and when I import it into a MySQL table it looks like this

["01151337941","01016749923"]

how can I modify the csv before I import so that it will look like this

01151337941,01016749923
Hazem Ahmed
  • 11
  • 1
  • 1
    Are the phone numbers? When you convert them to numeric values then you may lose the leading zero – Wernfried Domscheit Feb 11 '21 at 12:20
  • have you any common pattern in terminators ? – ROHIT KHURANA Feb 11 '21 at 12:20
  • you can also use Studio 3T trial version and export data in sql then import in mysql. – ROHIT KHURANA Feb 11 '21 at 12:23
  • **Telephone numbers are not integers!** Please, please, read [this](https://github.com/google/libphonenumber/blob/master/FALSEHOODS.md). And see this: https://stackoverflow.com/questions/42255754/phone-number-should-be-a-string-or-some-numeric-type-that-have-capacity-to-save/42255861#42255861 – O. Jones Feb 11 '21 at 12:27

0 Answers0