0

When I follow the Table Data Import Wizard I can see that it has successfully parsed the JSON file in the preview it provides. However, at the end, I see "0 records imported". This happens even with a simple JSON file, for example with contents {"name":"Name"}. I am using MySQL Workbench and server version 8.0.33.

Schema properties:

enter image description here

JSON file's contents:

enter image description here

Successfully parsing the JSON file:

enter image description here

However:

enter image description here

3
  • 1
    Perhaps showing the target table definition and the contents of the file you're trying to import will help people help you.
    – mustaccio
    May 29, 2023 at 15:41
  • The table is constructed automatically as its columns are inferred from the JSON file.
    – zach
    May 29, 2023 at 15:51
  • Pasting textual info as text is better than using images. May 29, 2023 at 21:25

1 Answer 1

1

Problem with char format of JSON file. So you may convert JSON into csv and test. Same situation with me, but in my case table has an amount column as float(8,2) and providing JSON file as [ {..., "amount": 800.00, ...},{...}, ...]. due to value 800.00 my record does not inserted in table from JSON file, so i just provide "amount":800 without decimal point and it worked for me.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.