Загрузка всех файлов директории в базу данных MySQL

@echo 
cd ..
cd ..
Set Folder= templates
Set file=K:\1.txt
For %%I In (%Folder%\*) Do  %%I
pause

echo INSERT INTO tablename ^(col1^) VALUES^('data1'^) | MySQL.exe -uroot -ppass

@echo off
setlocal ENABLEDELAYEDEXPANSION
cd ..
cd ..
Set Folder= templates
For %%M In (%Folder%\*) Do (
for /f "delims=" %%i in (%M%) do (
    set out=%%i
   echo INSERT INTO templates ^(Value^) VALUES^('!out!'^) | MySQL.exe -u root -p
   )
)%%M
pause

cd /d %systemdrive%

set folder=templates
for /f "delims=" %%i in ('dir /b "%systemdrive%\%folder%\*.*"') do (
  for /f "delims=" %%j in (%%i) do (
    echo INSERT INTO templates ^(Value^) VALUES^('%%j'^) | MySQL.exe -u root -p
  )
)

@echo off
setlocal ENABLEDELAYEDEXPANSION
cd ..
cd ..
set folder=templates
for /f "delims=" %%i in ('dir /b "%folder%\*.*"') do (
  for /f "delims=" %%j in (%%i) do (
    echo INSERT INTO templates ^(Value^) VALUES^('%%j'^) | MySQL.exe -u root -p
  )
)
pause

for /f "UseBackQ delims=" %%j in ("%folder%\%%i") do (

@echo off
setlocal ENABLEDELAYEDEXPANSION
cd ..
cd ..
cd templates
echo filename type values
for /r %%f in (*.*) do (
                   set filename=%%~nf  
                   set type=%%~xf
                   set values=%%f
 echo !filename!     !type!      !values!
echo INSERT INTO Templates (Ident,Type,Value) VALUES ("!filename!","!type!",LOAD_FILE('!values!')); | mysql -u root -p
)
pause