MySQL Forums
Forum List  »  Docs

How to Upload or inser the json file into mysql
Posted by: Vishnu Prabhu
Date: November 11, 2016 07:51AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
How to Upload or inser the json file into mysql
695
November 11, 2016 07:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.