Load_File returns a NULL value in MySQL / MariaDB

LOAD_FILE on execution in Windows operating system on Mysql database returns the null value on insertion

create table testfile ( sqlfile text)

insert into testfile values (load_file('C:\dump.sql'));
SELECT * FROM TESTFILE;
sqlfile
-------
       

Cause: It not taking the file path \ as \

Solution: Correct the path with double \\. It will insert the dump file into the column as its present in text file.

insert into testfile values (load_file('C:\\dump.sql'));

sqlfile             
--------------------
                    
          
-- MySQL dump 10.13