the instrument list API returns a gzipped CSV dump. How can store in mysql (CODE HELP)

sandy1990
the instrument list API returns a gzipped CSV dump. How can store in mysql (CODE HELP);
I am wondering to find the way to store response(big data) in mysql with php.
  • rakeshr
    @sandy1990
    You can iterate over complete instrument dump and store required items(trading symbol, expiry, exchange, segment, etc).
  • sandy1990
    Thanks Rakeshr, But my query was not that you answer, although i have find out the solution myself.
    Now i can explode by separator (\n). and get array of all data
Sign In or Register to comment.