How to Upload or inser the json file into mysql

[Vishnu Prabhu]

Hello Everyone,

I have some query regarding .json file.

i recive files from my cutomers in .json formt i want to upload the file in MYSQL Database but i dont know how to do.

For.csv file and .txt file this query works fine


LOAD DATA INFILE '/xxxxx.csv' INTO TABLE `xxx`
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n';


But i dont know how to do it for .json.

Can any one help me to resolve this problem.

Thank you in advance