How to store data in a database directly from azure blob container file url to mysql database

[Gaurav Kothari]

1st case :
LOAD DATA INFILE 'absolute_path_of_file'
INTO TABLE table_name
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;

Error: This command is not supported in the prepared statement protocol yet

2nd case :

LOAD DATA INFILE 'relative_path_of_file'
INTO TABLE table_name
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '
'
IGNORE 1 LINES;

Error: This command is not supported in the prepared statement protocol yet

As its official site gives note : As LOAD DATA isn't supported by COM_STMT_PREPARE yet, no LOCAL INFILE Request is expected here. This is unlike COM_QUERY Response.

Help me out with the solution for How to store data in a database directly from azure blob container file url to mysql database.